I have a hit logger tool, which does approximately 200,000 INSERTs a day into tables. The other application uses the same tables to run somewhat complex SELECT queries.
Since these tables will be large, SELECT queries are quite slow. Indexing the tables produced prefect results for these SELECT queries. But I guess inserting into a large indexed table may be a lot slower? So my question is, may DELAYED inserts solve my problem here, and allow me to keep those tables indexed? Is there any other trick that may solve my problem? Thank you for any attempt to help. Sherzod --------------------------------------------------------------------- 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
