Re: Abnormally low performance on INSERTS?

Erich Dollansky <[email protected]> Thu, 20 Oct 2005 16:26:48 +0800
Newsgroups gmane.comp.db.mysql.bugs
Organization oceanare pte ltd
Message-ID <[email protected]>
Hi,

Sture Eklund wrote:
> test sequence would take about 6 minutes. It includes ~250 000 INSERTS, so
> no extreme amount. If I would run the same test with my laptop, I estimate
> the time it would take to about 2½ hours... and the performance hit is more
> or less completely related to INSERTS.
> 
when it comes to laptops, the speed of hard disks is real slow.

What is the amount of RAM used in the machines. Sometimes, a lot of RAM 
can compensate this.

I have also a huge difference between normal machine an notebook. But 
this difference is roughly the same for all programs with intense disk 
access.

So, RAM could help in your case.

I never used MySQL on a notebook.

Erich

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]