By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,432 Members | 795 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,432 IT Pros & Developers. It's quick & easy.

getting in trouble with multiple insert...

P: n/a
Hi there,

i=B4m 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=B4s tweaking, isn=B4t 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=B4ll need the ORDER BY syntax again. And the query-speed goes
down to not usable ;(

To be honest, I don=B4t 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=FC=DFen / 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:
=20
1. This e-mail may constitute privileged information. If you are not the in=
tended recipient, you have received this confidential email and any attachm=
ents transmitted with it in error and you must not disclose, copy, circulat=
e or in any other way use or rely on this information.
2. E-mails to and from the company are monitored for operational reasons an=
d in accordance with lawful business practices.
3. The contents of this email are those of the individual and do not necess=
arily represent the views of the company.
4. The company does not conclude contracts by email and all negotiations ar=
e 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 su*****@activis.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/my***********...ie.nctu.edu.tw

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.