Hi guys,
I am currently evaluating different db options for our project... One of
our main issues are index, insertion and access time; therefore I have
several questions:
(1) Multiple Insert Statements
We need to insert around 300-500 datasets/sec constantly (24/7) with 8
till 16 fields indexed. So far we are using mysql, not only due to the
general dbms speed, but mainly because it has a csv import interface. We
figured out, that we can not insert that many data in row, when using
SQL statements, 'cause the SQL-parser just takes to much time... If we
use the CSV import methods, we gain at least a 30% performance boost.
While reading through the sqlite wiki, I found no evidence about any
multiple insert statement to decrease the SQL-Parsing time...
What would you guys propose?
(2) Indexing:
What kind of index implementations are you guys supporting/using?
B-Tree, R-Tree, Full-Text? What about Multiple-Column Indexes?
Supported?
Thanks in advance
& Greetings from Munich
.\\ichael
*****************************************************************************
Probleme mit Spam Mails?
Glauben Sie, Ihr Viren- und Spam Schutz kostet Sie zuviel?
Dann testen Sie e:scan V3 powered by postini kostenlos mit unserer Trial
Version!!
Mehr Infos unter:
http://www.integralis.de/services_managed_services_escan.php
*****************************************************************************
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.integralis.com
