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. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users