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:
=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.
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 support@activis .com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3...ie.nctu.edu.tw
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:
=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.
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 support@activis .com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3...ie.nctu.edu.tw