Nope, it's not throttled by default but a bad set of INI settings can ruin your day.
I also run MySQL locally on a laptop (with worse hardware figures than yours) and I have achieved Access to MySQL conversion speeds of 2000-8000 records per second (depending on the physical size of the record) through a VB Script through MyODBC. Your performance is uncharacteristically slow. Could your anti-virus be getting in your way (trying to check EVERYTHING that MySQL is writing to disk)? Are you making and breaking one connection per record? There are so many things that can affect performance, the more details you give, the more helpful we can be. (don't forget to CC the list on all responses) Shawn Green Database Administrator Unimin Corporation - Spruce Pine Andrew stolarz <[EMAIL PROTECTED]> wrote on 08/18/2005 03:53:54 PM: > Hi Shawn, > > I am using the MySQL ODBC driver to connect from our application to > the MySQL database, > > The actual server setting are default stright from the origional > install, I am running all this from my laptop localy (both MySQL and > MS SQL tests), P4 2.8GHZ, and 512mb ram. > > its doing about 10 records pre second for the transfer. which is dead slow. > > just want to knock off the option, MySQL is not limited anyway > without a license is it? > > Thanks > > Andrew Stolarz > > > On 8/18/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > Andrew stolarz < [EMAIL PROTECTED]> wrote on 08/18/2005 03:29:39 PM: > > > > Hi folks, > > I just downloaded MySQL 4.1 to see if its a go ahead with our application, > > I am doing a tranfser from our current datafile to MySQL, its taking about > > 45 min to do this process.. > > when I do the same process and transfer to a M$ SQL server, it takes about > > 2 min max. > > is the 4.1 of mySQL that I downloaded throttled somehow until I purchase > > the license for it? > > many thanks > > Andrew > > How _exactly_ are you "doing a transfer from our current datafile to > MySQL"? Not only can technique make a difference but some of your > server's settings may also need tweaking (based on the capaciity of > your hardware). How "beefy" is your server? How did you configure > your server's settings? Are you transferring this over a network or > is the source file local to the server? > > There are so many variables to consider.... > > Shawn Green > Database Administrator > Unimin Corporation - Spruce Pine
