Re: Abnormally low performance on INSERTS?

Hi, 

	I use MySQL in my Laptop, specially for devel, but sometimes with intense 
imports (as when I was writing the processor for my stats software - 
http://stats.camelot.co.pt), that was written with a bigger portal logs, and 
I had no abnormal performance issues, but I have 1GB of RAM, of which most of 
the time 512MB are buffers.

	I think that this can help a lot.

themage

On Thursday 20 October 2005 09:26, Erich Dollansky wrote:
> 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

-- 
Merlin, the Mage
http://www.sites-favoritos.com/user/merlin
http://www.cultodavida.online.pt
http://www.code.online.pt

Carpe Vitam

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