Hi,
what happens if I put all data in a single table and this table
become very huge (for example millions of rows)?
Will I have same performace problems?
The INSERTing profile has been covered by others but I'll just add
something about SELECT as well.
It depends on how you query it. i.e. what you put in the WHERE clause. If
it's by primary key ("WHERE <primary-key> <something> <something>") then it
will remain fast. If it's by other columns then you may need to add an
index. When you need to do this will depend on the exact nature of the
query.
If a query becomes slow you can prefix it with "EXPLAIN QUERY PLAN " to see
what it is doing. You can use that information to add the correct index.
Of course, when that happens, we can help you with interpretation of the
query plan if you want it.
Regards,
@ndy
--
andy...@ashurst.eu.org
http://www.ashurst.eu.org/
0x7EBA75FF
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
