Hi there,
I have a SQLite database which I’m using to store information in my educational app.
I need to store potentially up to millions of records in the database. These will all be simple text / integer records consisting of maybe 10 columns of data mostly containing one integer in each column.
All I want to know is whether there are likely to be any performance issues further down the line if I’m accessing and displaying data picked from millions of records. I wouldn’t be looping through the whole lot, just pulling back what was required using an appropriate SQL statement.
Is there anything else I need to be aware of here?
If anyone with experience of such things has a moment to respond that would be much appreciated.
Thanks,
Ian