MySQL is not limited in anyway if you don't have a license. The
default install is not optimal for the hardware you are running it
on. The default parameters are set pretty low so as not to monopolize
your system. If you are doing a big insert, you should adjust the
appropriate buffers (key_buffer_size, myisam_max_sort_file_size,
bulk_insert_buffer_size) . M$ SQL is kind of optimized out of the
box. MySQL allows you to really fine tune the database to fit your
needs, right down to using difference table types for your data.
Don't expect good performance by just installing and running. You
would actually want to set certain variables to one value for your
bulk insert and then change them for normal use.
On Aug 18, 2005, at 3:29 PM, Andrew stolarz wrote:
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
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
