What is the fastest database?

[Bob Sneidar]

If you plan on moving this to an external server, then you should not allow direct access to your SQL server (although I do so myself in development using On-Rev). You will probably want to access it through a web based script of some sort to firewall your SQL data. This will prevent things like SQL injection attacks and such. 

If this is your eventual goal, I would advise developing your application using this methodology right from the start. 

my 2¢

Bob


On Jul 25, 2011, at 2:51 PM, Keith (Gulf Breeze Ortho Lab) wrote:

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