Re: [sqlite] Big number of tables

2013-12-01 Thread James K. Lowden
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

Re: [sqlite] Big number of tables

2013-11-29 Thread Carlos Ferreira
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

Re: [sqlite] Big number of tables

2013-11-29 Thread Simon Slavin
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

Re: [sqlite] Big number of tables

2013-11-29 Thread Stephen Chrzanowski
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

Re: [sqlite] Big number of tables

2013-11-29 Thread Mohit Sindhwani
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

Re: [sqlite] Big number of tables

2013-11-29 Thread Stephan Beal
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..

Re: [sqlite] Big number of tables

2013-11-29 Thread Igor Tandetnik
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

[sqlite] Big number of tables

2013-11-29 Thread Carlos Ferreira
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 __