Hi there, iīm actually developing a performance criticial system where I need to index a huge amount of protocoll data.
These data are already in a chronological order, so if I push the data one by one in the database I will never need an ORDER BY syntax, `cause mysql already stores the data the right way. Thatīs tweaking, isnīt it ;) Unfortunatly I need more than 2000 inserts/sec, so simple inserts are just too slow. Therefore I used that WONDERFUL multiple insert statement and the speed was no problem any more. BUT with the multiple insert statment the chronological order will be lost and Iīll need the ORDER BY syntax again. And the query-speed goes down to not usable ;( To be honest, I donīt really see a reason WHY the chronological ORDER is lost this way, but maybe this problem could also be solved with a simple trick <g> Maybe one of the developer could say more? Or any other ways to deal with that problem? Mit freundlichen Grüßen / Kind Regards Michael Schoen System Development Activis GmbH Gutenbergstr. 1 D-85737 Ismaning Tel: +49-89-94573-450 Fax: +49-89-94573-479 http://www.activis.com/ Please note that: 1. This e-mail may constitute privileged information. If you are not the intended recipient, you have received this confidential email and any attachments transmitted with it in error and you must not disclose, copy, circulate or in any other way use or rely on this information. 2. E-mails to and from the company are monitored for operational reasons and in accordance with lawful business practices. 3. The contents of this email are those of the individual and do not necessarily represent the views of the company. 4. The company does not conclude contracts by email and all negotiations are subject to contract. 5. The company accepts no responsibility once an e-mail and any attachments is sent. http://www.activis.com This annotation was added by the e-scan service. http://www.activis.com ---------------------------------------------------------------------------------- This message has been checked for all known viruses by e:)scan. For further information please contact [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
