Stress-testing SQLite

Kee Nethery kee at kagi.com
Sat Oct 30 01:13:32 CDT 2010


many of the data stores for the major apple apps use sqlite. it's a petty robust single user data store. 
kee nethery


On Oct 29, 2010, at 5:32 PM, Mark Stuart wrote:

> on Fri Oct 29 19:17:40 CDT 2010, Richard Gaskin wrote:
>>> 
> Thanks in advance for sharing your experiences with large data sets if 
> SQLite.
> <<
> 
> Hi Richard,
> How many tables and how many columns per table (on average) are you
> talking about?
> That can make a big difference to the performance if there are JOINS
> involved.
> 
> If not, then that's not so much a problem.
> 
> Will the user always apply a WHERE filter to the data?
> What's the potential return record set count on a typical filter?
> 
> I'd be happy to do some stress testing if you can give me some details.
> 
> Regards,
> Mark Stuart
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution




-------------------------------------------------
I check email roughly 2 to 3 times per day. 
Kagi main office: +1 (510) 550-1336






More information about the use-livecode mailing list