471,897 Members | 1,396 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,897 software developers and data experts.

getting in trouble with multiple insert...

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

Please note that:
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.


This annotation was added by the e-scan service.
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
0 2135

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by sjoshi | last post: by
5 posts views Thread by Arsen V. | last post: by
7 posts views Thread by apattin | last post: by
9 posts views Thread by KDawg44 | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.