On 9/29/2019 7:10 PM, dmccunney wrote:
On Sat, Aug 3, 2019 at 11:57 AM Ben Collver <bencoll...@riseup.net> wrote:
Some day i would like to benchmark the DOS port of SQLite versus
databases such as Foxpro and Paradox. I understand these are not fair
comparisons because those old DOS databases supported the 8086. It is a
technical marvel that they worked as well as they did. I digress..
What would you be benchmarking?
SQLite is a full SQL compliant relational DBMS implemented as a single
library. dBASE and FoxPro were, IIRC "hierarchical" DBMS products.
Depending on what you are benchmarking this sounds like an apples and
oranges comparison.
Yes, FoxPro and Paradox supported the 8086. And FoxPro can be thought
of as a GUI version if Ashton-Tate's dBase, and that had roots back in
CP/M running non 8bit CPUs like the Intel 8080 and Zilog Z80.
Yes comparing SQlite to dBASE or FoxPro is comparing apples and oranges,
more like apples and potatoes actually...
Various dBASE versions (certainly II and III) work within the basic 1MB
confines of DOS space, other version can use (or might even require) a
few MB of expanded or extended RAM.
SQLite by default is using 2000 pages of 4096 bytes as caching buffer
(that's 8MB, in older versions the default page size was 1024 bytes). I
am not aware of a SQLite port for plain DOS (not newer Windows command
line!), but that certainly is far more RAM than a normal DOS can provide
(AFAIK, this has to be REAL RAM, not XMS/EMS).
And beside the RAM requirements, disk I/O speed is probably far more
important than in which kind of CPU code (16bit/32bit) is written. Not
to mention that SQLite is a library to be included/linked into your own
application, while dBASE and derivatives are applications (which can be
programmed with their own language) all by themselves...
Ralf
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
_______________________________________________
Freedos-user mailing list
Freedos-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/freedos-user
