Thierry Coopman writes: > At 16:10 +0300 07-06-2001, Sinisa Milivojevic wrote: > > Is there a way to tune MySQL for a lot of updates? most performance > tunings consider selects not updates. > Since the table is in memory, I guess HDD speed is not a factor (on a > SunFire280R those are FCAL disks). > > My guess is that the Cache Memory on the processor speeds things up a > lot (UltraSparc III has 8MB), but I'm not sure how 2 CPU's will > perform. > > Also having splitting the updates over multiple treads seems to > improve speed a little. > > > -- > Thierry Coopman - [EMAIL PROTECTED] > My opinions are personal, and have really nothing or nothing to do > with Keytrade! > > #RandomTag > Hi! Yes, there is. If you have enough memory, you can use write-through HEAP tables to speed up things. -- Regards, For technical support contracts, go to https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus <___/ www.mysql.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php