Timeline for SQLite - Should I add some indexes even if select queries are fast?
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Nov 2, 2016 at 13:05 | comment | added | bwilliamson | Performance, unfortunately, isn't an exact science. Part of we consider is what is good enough versus what is needed. Keep in mind that adding indexes can indeed increase performance, however each index creates a duplicate of your data that any DUI ( Delete, Update, Insert ) will have to modify as well and that will take more time all the way around, including maintenance. | |
| Nov 2, 2016 at 9:20 | comment | added | monamona | We will have some select on these tables and also insert.. | |
| Nov 2, 2016 at 9:20 | comment | added | monamona | Thanks for your answer. we don't have any issued with the current DBs, but there are some of our tables that will get larger during the time and that's why I asked if I have to consider applying indexes on those tables.. | |
| Nov 1, 2016 at 14:30 | history | answered | bwilliamson | CC BY-SA 3.0 |