Hi,
I need to setup an ODBC link over our Internet connection between MS Access
(local) and a MySQL server (Remote - the local PC has the MySQL ODBC driver
installed). What kind of bandwidth requirements am I looking at? Will it
function over a 64k leased line? If this would be slow, could there be any
major impact on other uses such as web and email?
Regards,
Dominic 8 3551
In message <c0************ *******@news.de mon.co.uk>, Dominic Martin
<do************ @dplm.co.uk> writes Hi,
I need to setup an ODBC link over our Internet connection between MS Access (local) and a MySQL server (Remote - the local PC has the MySQL ODBC driver installed). What kind of bandwidth requirements am I looking at? Will it function over a 64k leased line? If this would be slow, could there be any major impact on other uses such as web and email?
It's certainly feasible to run an ODBC connection over a 64k link, and I
have done so. You haven't really given enough information to answer the
question. You need to know how many data requests will be issued and how
much data will have to be retrieved for each request.
You may need to consider the time distribution of the requests, will
they all occur at the same time? How long are the users willing to wait
for their data? What else will be using the line at the same time? Will
those users be prepared to wait for their data?
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.
"Bernard Peek" <ba*@shrdlu.com > wrote in message It's certainly feasible to run an ODBC connection over a 64k link, and I have done so. You haven't really given enough information to answer the question. You need to know how many data requests will be issued and how much data will have to be retrieved for each request.
You may need to consider the time distribution of the requests, will they all occur at the same time? How long are the users willing to wait for their data? What else will be using the line at the same time? Will those users be prepared to wait for their data?
Thank you for your response. The ODBC access will supplement web based
access, where the web server will be on the same local network as the MySQL
server. The web access will be used mostly for simple queries. The ODBC
access is to be used for more complex ad-hoc queries. So in answer to your
questions, only one person is ever likely to access the MySQL database via
ODBC at a time. The reports do not need to be done instantly, so time is not
too much of a worry.
I'm assuming that these are all good answers. What number of users and level
of data did you pass over the 64k link?
Dominic
Bernard Peek London, UK. DBA, Manager, Trainer & Author. Will work for money.
In message <c0************ *******@news.de mon.co.uk>, Dominic Martin
<do************ @dplm.co.uk> writes "Bernard Peek" <ba*@shrdlu.com > wrote in message It's certainly feasible to run an ODBC connection over a 64k link, and I have done so. You haven't really given enough information to answer the question. You need to know how many data requests will be issued and how much data will have to be retrieved for each request.
You may need to consider the time distribution of the requests, will they all occur at the same time? How long are the users willing to wait for their data? What else will be using the line at the same time? Will those users be prepared to wait for their data? Thank you for your response. The ODBC access will supplement web based access, where the web server will be on the same local network as the MySQL server. The web access will be used mostly for simple queries. The ODBC access is to be used for more complex ad-hoc queries. So in answer to your questions, only one person is ever likely to access the MySQL database via ODBC at a time. The reports do not need to be done instantly, so time is not too much of a worry.
I'm assuming that these are all good answers. What number of users and level of data did you pass over the 64k link?
You can work out the data capacity of the link by looking at the
structure of the tables returned and the number of records retrieved.
The number of users isn't important, just the amount of data they use.
That's very difficult to predict with ad hoc reports. Either the person
creating the reports needs to understand the bandwidth they have
available or you have to find a way of saving bandwidth. Have you
considered replicating the MySQL database to a local server?
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money.
I have done some work on a database using ODBC over a 64K leased line. The
people paying the bills thought it was "acceptable ", but the actual users
thought it abominable. The users didn't find it acceptable until the lines
(one each to three separate user locations) were upgraded from 64KB to T-1
(which is about 1.5MB, as I recall).
A better-written application would have performed better, but the same
people paying the bills wouldn't pay for some obvious improvements, such as
opening the main/first form on a single record rather than on an entire
15,000 record table. But only parts of the app were so poorly
designed/implemented.
Larry Linson
Microsoft Access MVP
I have done so over ADSL lines (128k upload).
Adhoc queries that returned resonable amounts of data felt OK to me. The
important point is to send the query to the server and have it do the grunt
work - avoiding queries where raw data is returned to Access while it does
the grunt work. However the typical Access form performed substantially
worst - edge of usability.
When you try going long distances or overseas (large latency in the
internet - distance being defined as #routers, hops etc. as opposed to miles
per-se) then things become very bad, because by default Access does not take
care to minimize the amount of round-tripping. So the time is multiple
latency plus data transfer.
"Dominic Martin" <do************ @dplm.co.uk> wrote in message
news:c0******** ***********@new s.demon.co.uk.. . Hi,
I need to setup an ODBC link over our Internet connection between MS
Access (local) and a MySQL server (Remote - the local PC has the MySQL ODBC
driver installed). What kind of bandwidth requirements am I looking at? Will it function over a 64k leased line? If this would be slow, could there be any major impact on other uses such as web and email?
Regards,
Dominic
"Bernard Peek" <ba*@shrdlu.com > wrote in message
news:I2******** ******@shrdlu.c om... In message <c0************ *******@news.de mon.co.uk>, Dominic Martin <do************ @dplm.co.uk> writes "Bernard Peek" <ba*@shrdlu.com > wrote in message It's certainly feasible to run an ODBC connection over a 64k link, and
I have done so. You haven't really given enough information to answer the question. You need to know how many data requests will be issued and
how much data will have to be retrieved for each request.
You may need to consider the time distribution of the requests, will they all occur at the same time? How long are the users willing to wait for their data? What else will be using the line at the same time? Will those users be prepared to wait for their data? Thank you for your response. The ODBC access will supplement web based access, where the web server will be on the same local network as the
MySQLserver. The web access will be used mostly for simple queries. The ODBC access is to be used for more complex ad-hoc queries. So in answer to
yourquestions, only one person is ever likely to access the MySQL database
viaODBC at a time. The reports do not need to be done instantly, so time is
nottoo much of a worry.
I'm assuming that these are all good answers. What number of users and
levelof data did you pass over the 64k link?
You can work out the data capacity of the link by looking at the structure of the tables returned and the number of records retrieved. The number of users isn't important, just the amount of data they use.
That's very difficult to predict with ad hoc reports. Either the person creating the reports needs to understand the bandwidth they have available or you have to find a way of saving bandwidth. Have you considered replicating the MySQL database to a local server?
Yes, but the MySQL server is a hosted solution, so we're limited in the ways
that we can get hold of the data. It's either CSV copies of the tables or
the ODBC read only link to the live data. Apart from setting up a SQL server
locally, I'm not sure what else we would need to do. Are you suggesting that
the local SQL server would use ODBC just to make straight copies of the data
or that we would have to download and manually import the CSV files? Under
the latter, it is more likely that we would just import the CSV files
directly into MS Access.
When you say you can work out the data capacity of the link, is there a
rough formula that can be applied. i.e. a certain number of records from a
certain number of tables would require x amount of bandwidth?
Thank you for your continuing help.
Dominic
-- Bernard Peek London, UK. DBA, Manager, Trainer & Author. Will work for money.
"User" <Us**@aol.com > wrote in message
news:OW******** ******@TK2MSFTN GP11.phx.gbl... I have done so over ADSL lines (128k upload).
Adhoc queries that returned resonable amounts of data felt OK to me. The important point is to send the query to the server and have it do the
grunt work - avoiding queries where raw data is returned to Access while it does the grunt work. However the typical Access form performed substantially worst - edge of usability.
Thank you for your comments. How do you ensure that the query is sent to the
server to do the work and not have the raw data returned to Access? Is it
something that you have to build into the query?
Dominic When you try going long distances or overseas (large latency in the internet - distance being defined as #routers, hops etc. as opposed to
miles per-se) then things become very bad, because by default Access does not
take care to minimize the amount of round-tripping. So the time is multiple latency plus data transfer.
"Dominic Martin" <do************ @dplm.co.uk> wrote in message news:c0******** ***********@new s.demon.co.uk.. . Hi,
I need to setup an ODBC link over our Internet connection between MS Access (local) and a MySQL server (Remote - the local PC has the MySQL ODBC driver installed). What kind of bandwidth requirements am I looking at? Will it function over a 64k leased line? If this would be slow, could there be
any major impact on other uses such as web and email?
Regards,
Dominic
In message <c0************ *******@news.de mon.co.uk>, Dominic Martin
<do************ @dplm.co.uk> writes You can work out the data capacity of the link by looking at the structure of the tables returned and the number of records retrieved. The number of users isn't important, just the amount of data they use.
That's very difficult to predict with ad hoc reports. Either the person creating the reports needs to understand the bandwidth they have available or you have to find a way of saving bandwidth. Have you considered replicating the MySQL database to a local server? Yes, but the MySQL server is a hosted solution, so we're limited in the ways that we can get hold of the data. It's either CSV copies of the tables or the ODBC read only link to the live data. Apart from setting up a SQL server locally, I'm not sure what else we would need to do. Are you suggesting that the local SQL server would use ODBC just to make straight copies of the data or that we would have to download and manually import the CSV files? Under the latter, it is more likely that we would just import the CSV files directly into MS Access.
MySQL supports replication, so that any changes to a master database are
automatically copied to a slave database. You would keep the master
database on the server and run all of your queries against the slave
kept on your own site. You need to talk to your hosting provider about
that, they may have other customers doing the same thing.
If your data changes slowly it may be OK to copy the data to CVS files
once per day and to copy them when the 64k bandwidth isn't being used
for anything else, perhaps overnight. That way you could run queries
against a database that is less than 24 hours old and not need to use
bandwidth during the day. When you say you can work out the data capacity of the link, is there a rough formula that can be applied. i.e. a certain number of records from a certain number of tables would require x amount of bandwidth?
The amount of data to transfer depends on the size of the records. List
the fields in each table and determine the number of bytes required for
each of them. Multiply that by the number of records retrieved. Decide
how long it will take to transfer that data over a 64Kbit (8Kbyte) per
second link. Take account of other people using the same link for other
purposes.
--
Bernard Peek
London, UK. DBA, Manager, Trainer & Author. Will work for money. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Lorenzo Bolognini |
last post by:
Hi all,
i need to detect whether a field is required or not. I'm using this code for
building a string to convert later to an array (by Split) of which each
element matches the field index (ex. Field(myArray(0)):
For Each Field in rst.Fields
If Field.Attributes And adFldIsNullable Then
Required = 0 'field is NOT required
Else
|
by: Andreas Lauffer |
last post by:
I changed from Access97 to AccessXP and I have immense performance
problems.
Details:
- Access XP MDB with Jet 4.0 ( no ADP-Project )
- Linked Tables to SQL-Server 2000 over ODBC
I used the SQL Profile to watch the T-SQL-Command which Access ( who
creates the commands?) creates and noticed:
|
by: Mark |
last post by:
Hi
I have two SQL2000 servers in different sites, once a day approximately
1M of data in the form of a large update is required to be transfered
between the 2. We have use of a 2M pipe between the servers but there
is no quality of service, the other users on the pipe are traders so
there must be no interruption in the quality of their bandwidth at any
time.
Is there any way of throttling back the data transfer between the two
servers...
|
by: Andreas Lauffer |
last post by:
Can anyone tell me advantages / disadvantages of DataDirect Server
Wire ODBC-driver?
Any experiences?
What about redistribution?
Andreas Lauffer, easySoft. GmbH, Germany
|
by: Dave |
last post by:
Hey guys, I have an ODBC problem that has me stumped. I wrote a VBA
script to run in Microsoft Excel that pulls data out of an application
using that application's ODBC driver and puts it into Excel. I am
trying to translate the same program over to Microsoft Access and I ran
into a problem. Access locks up if the data I am querying for is not
present in the database.
To retrieve data from the database of the application, my Excel...
| |
by: timandsuzi36 |
last post by:
I have a WinForms App that is launching an Access 2003 db Reports
program. I am using the System.Diagnostics.Process object to do so.
I thought that I could pass my db connection string to Access using the
Process.StartInfo.Arguments with the /cmd switch like so.
System.Diagnostics.Process i = new System.Diagnostics.Process();
i.StartInfo.WorkingDirectory = "C:\\ACAReports";
i.StartInfo.FileName = "Reports.mdb";
i.StartInfo.Arguments...
|
by: Ryan Moore |
last post by:
I'm trying to make a "bandwidth analyzer" using C# (ASP.NET) which will
display the amount of bandwidth used by a website, broken down by direcotry
within the site.
I'm considered analyzing log files to do this or possibly SNMP.... has
anyone ever done something similar and what's a good way to go about it?
thnx
|
by: bazzer |
last post by:
hey,
im trying to access a microsoft access database from an ASP.NET web
application in visual basic 2003.NET. i get the following error when i
try running it:
Server Error in '/CinemaBookingSystem' Application.
--------------------------------------------------------------------------------
ERROR General error
Unable to open registry key 'Temporary (volatile) Jet DSN for process
|
by: sdavis1970 |
last post by:
I am working on an Access 2002 database where one of the tables has
five required fields making up the key.
There is a form that is linked to this table which is used for adding
new records.
There is a close button on this form that has the following code in
it's OnClose event:
"DoCmd.close"
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |