Hello, I have a query about 'SELECT' query's performance when we have one huge table vs. multiple small tables.
Basically in our application, we need to run select query multiple times and today we have one huge table. Do you guys think breaking them into multiple small tables will help ? For test purposes we tried creating multiple tables but performance of 'select' query was more or less same. Note :- We already have indexing in place. Thanks. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users