>
> 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
>
>
>