What is the fastest database?

[Andre Garzia]

On Mon, Jul 25, 2011 at 7:49 PM, Bob Sneidar <bobs at twft.com> wrote:

> 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¢
>

what he said!


>
> 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
>
>
> _______________________________________________
> 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
>



-- 
http://www.andregarzia.com All We Do Is Code.