Did I ask for optimization tips? Nope. ;)
But I did ask for a release date of version 4.1. > -----Original Message----- > From: Land, Christopher > Sent: Friday, April 12, 2002 11:18 PM > To: Jon Frisby; Mysql List > Subject: RE: MySQL and stored procedures -> v4.1 :( > > > 5.2.12 Other Optimisation Tips > http://www.mysql.com/doc/T/i/Tips.html > > ... > - Normally you should try to keep all data non-redundant (what is called 3rd > normal form in database theory), but you should not be afraid of duplicating > things or creating summary tables if you need these to gain more speed. Optimizing for what kind of need for speed? Redundancy kills speed performance for inserts and updates... > - Stored procedures or UDF (user-defined functions) may be a good way to get > more performance. In this case you should, however, always have a way to do > this some other (slower) way if you use some database that doesn't support > this. A nice thing with a stored procedure is that you can lower the load impact made by heavy queries on the database by using cursors to soften the performance hit they are likely to make - e.g. make the query behave like a high intensive interactive user instead of a huge one single shot batch job. > - You can always gain something by caching queries/answers in your > application and trying to do many inserts/updates at the same time. Let's say I need to do 10 millions inserts. In what way will bundling all these 10 million inserts into one single batch give me some gain? > If your database supports lock tables (like MySQL and Oracle), this > should help to ensure that the index cache is only flushed once after > all updates. If you have a frequent interactive used system, then the time spent in high transaction isolation levels should kept to a minimum. Giving general thump rule advices about how to implimenbt a system whithout having knowledge about the intention of a system is like saying that one should spit on the left side of the boat - just to bad if you have the wind in the face when you do it... --------------------------------------------------------------------- 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
