Hi, I need to create multiple tables all having the same schema. The number/names of the tables will by dynamic. There would be somewhere in the order of 10 to 100 of these tables. When doing operations on these tables, I want to avoid having to do a prepare_query every time for performance reasons. Since the tables have exactly the same schema, in theory I should be able to use the same prepared statement on any one of those tables. Any ideas on if this is possible?
The other options I'm looking at are: 1. dynamically caching prepared queries 2. use only one table with an extra index. With only 10-100 tables merged into one, I figure the extra index would take an extra log100 -> ~10 lookups in the binary search. The thing is, I need to keep a cursor to where in the table I was last searching, so I can continue the search from where I left off, which is why using multiple tables was preferable; i.e., i can track the row_id, and then resume the search there (WHERE row_id > cursor_row_id). Any ideas? Thanks, _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
