The bind functionnality will help you do so as well as the transaction
mode. When binding you do not recompile the statement and using the
begin/commit transaction will avoid commiting changes at every line.
In debug mode I can insert up to <1 per ms with a table of 10 fileds but
with only one index.
something like following:
GetLocalTime(&tmStart);
_myDB.execDML("begin transaction;");
for (int i = 0; i < 1000; i++)
{
sprintf(buf, "name%06d", i);
stmt.bind(1, i);
stmt.bind(2,i);
stmt.bind(3, buf);
stmt.execDML();
stmt.reset();
}
_myDB.execDML("commit transaction;");
GetLocalTime(&tmEnd);
Benjamin Filippi
Capital Fund Management
6 boulevard Haussmann 75009 Paris
Tel: +33 1 49 49 59 30
Fax: +33 1 47 70 17 40
[EMAIL PROTECTED]
http://www.cfm.fr
"Michael Schoen" <[EMAIL PROTECTED]>
09/02/2005 11:59 AM
Please respond to sqlite-users
To: <[email protected]>
cc:
Subject: [sqlite] Some interesing questions ;)
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
