What is the fastest database?

Keith (Gulf Breeze Ortho Lab) keith at gulfbreezeortholab.com
Mon Jul 25 17:51:00 EDT 2011


Hello,

I have approximately 25 MB of data (plain text) that consists of approximately 140,000 different entries (one per line--pipe delimited). I am working on an application to quickly search through the data not unlike the LiveCode Dictionary application. However, it will be necessary for my users to be able to edit any entry at will.

For a desktop application, what database would you recommend for the job? I can use a flat file database, but the problem is that all 25 MB of data must be loaded into memory... What about SQLite? Valencia? Speed is of the essence.

FYI: In the past I used an Access database, but it was too sluggish for my purposes.

Any recommendations/feedback is most welcome. Thanks.

LiveCode is awesome!

Sincerely,

- Boo


More information about the use-livecode mailing list