473,320 Members | 1,902 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 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
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
0 2198

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: jason | last post by:
How does one loop through the contents of a form complicated by dynamic construction of checkboxes which are assigned a 'model' and 'listingID' to the NAME field on the fly in this syntax:...
1
by: John Smith | last post by:
I have a user assigned multiple roles and a role can be inherited from multiple parents (see below). How do I answer such questions as "How many roles does the user belongs to?" I answered the...
2
by: sjoshi | last post by:
I'm trying this simple query but getting multiple listings for change_number field SELECT c.Change_Number, c.Submission_Date, c.Short_Description, c.CurrentStatus, dlv.Name, s.Description,...
5
by: Arsen V. | last post by:
Hello, What is the optimal way to insert multiple rows (around 1000) from a web application into a table? The user enters multiple lines into a text box (up to 10,000). The ASP.NET...
41
by: pb648174 | last post by:
In a multi-user environment, I would like to get a list of Ids generated, similar to: declare @LastId int select @LastId = Max(Id) From TableMania INSERT INTO TableMania (ColumnA, ColumnB)...
7
by: apattin | last post by:
Hi experts, I am having a hard time coding a trigger to handle multiple validation conditions in DB2 UDB V8.1.9.. I thought that a single trigger might be better than one-trigger-per-condition,...
0
by: Neil | last post by:
Here's a follow-up to my "Concatenating Rich Textbox Controls Into A Single File" message. I didn't get any useful responses to that message, so I assume that there isn't a direct way to create a...
4
bugboy
by: bugboy | last post by:
I'm inserting a new word into table 'w' and a definition into table 'c' which are linked in table 's' which is the relation table for the many to many relationship between 'w' and 'c'. I've been...
9
by: KDawg44 | last post by:
Hi, I have PHP function that adds a record to the database. The table has an ID that is AUTO_INCREMENT. Is there anyway to get that ID back when I do any kind of insert? That ID is a foreign...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.