[REBOL] Re: REBOL and database stuff
From: greggirwin:mindspring at: 30-Mar-2003 19:55
Hi Mat,
MB> Certainly not too late for me to shift!
Shouldn't be too different, at least to see which works best for you,
and as Tim said, it works with Core.
MB> I guess that's not really important now we've established the rows
MB> don't have 5000 fields :)
:) Well, I haven't used db.r, but I just glanced at it and it loads
each line individually it seems, and creates just an empty block to
load them into as a starting point. If loading the database is what's
slow for you, just changing those things might help quite a bit. Also,
if doing lots of inserts deletes, using a list! would be faster for
that. It does a linear search to delete a record, so that could
probably be sped up as well. Same for update. Selecting records could
probably be sped up as well, but I'd have to spend more time to see
what he's actually doing.
MB> Nothing that's not in that lovely db.r really. It's just that it'd
MB> probably get very slow or break with 5000 records.
Gotta profile it to be sure, unless you already know exactly what
parts are slow about it.
MB> My immediate requirement is 3000 records and I had set about doing
MB> that with db.r and suspected it would work. But I thought better to do
MB> the work now, for when I need to do one later in the month with 50,000
MB> records.
For 50K records you probably want a true DB.
MB> I also thought it'd be pretty fast. However just inserting a new row
MB> into a datbase with less than ten fields... it's only doing 2-3 a
MB> second. Can that be entirely down to the MySQL server being on another
MB> machine? Surely it's faster than that?
Dunno. I've heard that MySQL can peform pretty well and I'd have to
guess that not many big folks would use it if that was as fast as it
went.
-- Gregg