[sqlite] massive insert

I have a table where i insert data massively near 10,000 or 20,000 rows and that take to much time, near 1h for each 10,000 rows. How i can increase the performance for this operation?. In other case... How i can insert multiples rows in one INSERT statment?? Thanks.

RE: [sqlite] query limited

Yes, this is exactly that i need. thanks. CiberCorreos® Acercando las Nuevas Tecnologías a la población. http://www.ciudadano.cu/ - To unsubscribe, send email to [EMAIL

[sqlite] query limited

Hello, somebody know a way for create a query limited, for example, select 100 lines of a table that have 100, without to use where clause, like do Ms SQLServer with select top. Thanks. CiberCorreos® Acercando las Nuevas Tecnologías a la

Re: [sqlite] Re: problem with tilde

Thanks you for all information, i am using turbo delphi, exists a function UTF8Decode, i am using it for solve de problem, it function convert of UTF-8 to WideString. > Hello [EMAIL PROTECTED], > >> I am using SQliteSpy 1.5.5 for to execute de sql statement for fill the >>table. > > SQLiteSpy is

Re: [sqlite] Re: problem with tilde

> [EMAIL PROTECTED] wrote: >> Hello, somebody know why the tilde do not show correctly. >> I am using Turbo Delphi and the unit SQLiteTable3 for access to the >> database in sqlite 3, but, the text that I see is, for example: >> >> Calcula la media móvil simple >> >> it must be >> >> Calcula la

[sqlite] problem with tilde

Hello, somebody know why the tilde do not show correctly. I am using Turbo Delphi and the unit SQLiteTable3 for access to the database in sqlite 3, but, the text that I see is, for example: Calcula la media móvil simple it must be Calcula la media móvil simple Thanks