On 7/26/11 12:51 AM, "Keith (Gulf Breeze Ortho Lab)"
<ke...@gulfbreezeortholab.com> 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.
Hi Keith,
Our Valentina database :-)
1) It is faster in 50-100 times (usually) of any RDBMS as SqlLite, mySQL,
Postgre, MS SQL, Access.
Because Valentina DB is columnar, and because of many other things.
2) Vertica is good but they say much much more expensive.
If you need more details let me know.
May be you can find useful this page
http://www.paradigmasoft.com/en/testimonials
3) in fact, 25MB and 140k records is quite small database :-)
Why you think you need super-speed?
Our users did have e.g. 40 million records, 30-40GB and more...
--
Best regards,
Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
http://www.paradigmasoft.com
[I feel the need: the need for speed]
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
