Hello.
There could be a lot of reasons for such a delay. First, you should switch to bulk inserts and perform all operation as a single transaction. Avoid usage of the autoextended or per-table tablespaces. Are you able to upgrade? There could be some performance improvements in the newer versions. [EMAIL PROTECTED] wrote: > > Hi, > > I have an interesting problem, i.e upto 20k data is inserted in 20 > min. But for 39k it took 3.5 hours. Could you please help me in this, > what are all the possible scenarios which leads to this kind of > problems. Is there any fine tuning mechanism in Mysql 4.0.23 with > innodb? > > Please help me in this, it is very urgent. > > Thanks, > Narasimha > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
