On Fri, 29 Nov 2013 13:33:59 +
Carlos Ferreira wrote:
> If I have to create more than 1000 empty tables to initialize my
> application document it takes a while..
Why ship an application with logic to create 1000 empty tables? Why
not ship 1000 empty tables in a predefined database?
--jk
Thank you guys.
I am going to try it.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Stephan Beal
Sent: sexta-feira, 29 de Novembro de 2013 14:17
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Big number of
On 29 Nov 2013, at 1:33pm, Carlos Ferreira wrote:
> If I have to create more than 1000 empty tables to initialize my application
> document it takes a while..
>
>
>
>
>
> Is there any workaround?
Do these tables have different columns ? If not, then create one table and use
a column inst
As others have suggested, transactions, create a single file and just copy,
or throw it in memory (And as an extra thought to creating it in memory is
once created, throw it to disk via the Backup API then --if needed-- work
off that).
Another option, but probably not the best idea, is each time a
Hi Carlos,
On 29/11/2013 9:33 PM, Carlos Ferreira wrote:
Any of you know how to speed up the creation of empty tables in SQlite?
If I have to create more than 1000 empty tables to initialize my application
document it takes a while..
Is there any workaround?
Workaround:
1. I would probably c
On Fri, Nov 29, 2013 at 2:37 PM, Igor Tandetnik wrote:
> On 11/29/2013 8:33 AM, Carlos Ferreira wrote:
>
>> Any of you know how to speed up the creation of empty tables in SQlite?
>>
>> If I have to create more than 1000 empty tables to initialize my
>> application
>> document it takes a while..
On 11/29/2013 8:33 AM, Carlos Ferreira wrote:
Any of you know how to speed up the creation of empty tables in SQlite?
If I have to create more than 1000 empty tables to initialize my application
document it takes a while..
Make sure you run all CREATE TABLE statements within a single
transact
Hello,
Any of you know how to speed up the creation of empty tables in SQlite?
If I have to create more than 1000 empty tables to initialize my application
document it takes a while..
Is there any workaround?
Thanks
Carlos
__
8 matches
Mail list logo