Chris- 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 [email protected] _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
