Am Sonntag, 20.07.03 um 17:23 Uhr schrieb Randal L. Schwartz:
I know SQLite (and you can easily use it from C or ObjC, too, BTW). But I don't even think we need a SQL database. Using DB should work as well (but might be easier to implement)."Max" == Max Horn <[EMAIL PROTECTED]> writes:
Max> I don't think any of our performance problems are due to perl anyway,
Max> and so far nobody (including Kyle) has been able to prove
Max> otherwise. All bottlenecks I see so far are disk I/O related, or due
Max> to suboptimal algorithms (i.e. our abuse of storable is becoming a
Max> speed issue, the data involved simply is to big for it). Fixing that
Max> will require a rewrite of parts in any case; but of course rewriting a
Max> (well modularized) part of code is much easier than rewriting
Max> everything from scratch, so I am still skeptic.
You should look into DBD::SQLite then... a complete SQL engine with transactions, subselects, views, etc... but without the server running! The entire engine is included in the DBD::SQLite distro. It's really rather remarkable.
However, all this is very theoretical. There are many smaller and bigger issues when using a "real" DB instead of a perl hash. For example the fact that we have completely variable number of fields in a package; most DBs (including all (rational) SQL DBs) have a fixed set of records. In a certain sense, using an OO DB would fit much better into the way Fink would make use of the DB. Making use of any "classic" DB means that we have to jump through various hoops and loops to fit (force?) Fink's idea of a package DB into it.
So, instead of discussing whether to use a SQL based DB or a "direct" accessed DB, I would find it much more interesting to check a) if there is a suitable & fast OO (instead of relational) DB available, or b) a wrapper for any of the classical DBs which allows variable fields, or c) if neither, how we can actually combine our requirements (variable list of fields, some containing multiple values (think dependencies, for example) with what we can get...
Cheers,
Max
------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here: http://www.vmware.com/wl/offer/345/0 _______________________________________________ Fink-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/fink-devel
