Deryck, others: I'm doing some reading on InnoDB and am pretty ignorant on the subjets. Can someone explain why would InnoDB be faster than MySQL? From what I read it looks like it will have more overhead to support the transactions and that should decrease the performance rather than improve it. I think I read something to that effect in one of the manuals (but I don't rememeber which one). Could someone shed some light on this please
thanks AOD > > OK, I will soon have a huge database, home to about 500,000,000+ records > and > > believe that MySQL needs to be faster. I have heard good things about > > InnoDB but Ihave no idea what it is. Can someone please tell me (or give > a > > url telling) what it is, the benifits, how I can set it up on an already > > existing database, and what it can do for me. Thank you. Also, if anyone > > knows a very good search query for this that would be good for a high-end > > search engine (google, yahoo, etc), please let me know. Thank You. __________________________________________________ Do You Yahoo!? NEW from Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 --------------------------------------------------------------------- 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