SQLite data storage

Mark Wieder mwieder at ahsoftware.net
Thu Mar 21 13:02:24 EDT 2013


Caveat: I know enough about databases to be dangerous, so if someone else chimes
in with conflicting information, ignore this.

I don't think you'll run into any problems with SQLite performance for what
you've got in mind. And anything beats Excel. Is there a reason the data is
separated into 24 sheets? Since the data is all of a common format then it would
be better normalized if you put it all in the same table. If the sharding makes
it easier to retrieve data then you'll get slightly better performance if you
keep it as 24 tables, but otherwise I'd just throw it all together - it will
make your queries easier, especially if you have to combine data from the
different sheets.

 Mark Wieder
 mwieder at ahsoftware.net

More information about the Use-livecode mailing list