Search found 2 matches

by aggg63
05.03.2009, 11:44
Forum: SQLite
Topic: Slow creating database
Replies: 3
Views: 591

Solved

First

Code: Select all

ZConsultaBD.SQL.Text('BEGIN');
ZConsultaBD.Open;
NO work

Code: Select all

ZConexion.StartTransaction;
Last

Code: Select all

ZConsultaBD.SQL.Text('COMMIT');
ZConsultaBD.Open;
Thanks. (Thank you Martin)
by aggg63
04.03.2009, 14:24
Forum: SQLite
Topic: Slow creating database
Replies: 3
Views: 591

Slow creating database

Hello. I'm working in a little database with SQLite. Till now I'm using CNPack for SQLite2. Works very well, It make 3 tables and 1 index in 10 seconds or less. The tables are populating with records and the greatest have 1700 records with 5 fields. I repeat, all in 10 seconds. I find Zeos component...