On Sun, Aug 22, 2010 at 4:51 AM, Mike Zang <mikez...@yahoo.co.jp> wrote: > I have 5000 files and I want to converrt them to SQLite3 on iPad, now I > have a performance question, I am not sure which way is better for select > and insert data in SQLite3. > > I have two ideas for converting. > > 1. convert 1 file to 1 table, so that I will have about 5000 tables in > SQLIte3 database, and any file will have about 3000 records. > > 2. convert all 5000 files to 1 table, there will be 15000000 records. > > Please give a suggestion before I start my programming.
Don't know how generalizable this is but I tried this with a single 10+ GB table made up of ~ 1000 similarly formatted tables of ~ 75k records each. This is running on a USB drive under Windows Vista and SQLite version 3.6.18. I tried adding two indexes. The first " create index " took a few minutes to an hour to create and I killed the second " create index " after it was still going 24 hours later. " select count(*) " takes 5 minutes to run but " select count(*) from data where x = 'X' " returns immediately where x is the first column in the index that succeeded. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
