[REBOL] REBOL/Command vs Doc's MySQL scheme
From: mat:plothatching at: 31-Mar-2003 8:57
Hello Gregg,
GI> Shouldn't be too different, at least to see which works best for you,
GI> and as Tim said, it works with Core.
Inside of a few minutes, I'd turned my script into using DocKimbles's
MySQL scheme. The results were... surprising.
Take a look at these timings;
REBOL/Command;
>> system/version
== 2.0.0.3.1
>> do %listsql.r
Script: "Untitled" (none)
SQL database openned.
>> databaseinit
Initialised vw1...
Initialised vw2...
Initialised vw3...
Initialised vw4...
0:00:01.742
>> importallcsv
0:01:28.157
Nearly 2 seconds to create four tables. A minute and a half to import
400 odd records from a CSV.
Now let's look at REBOL/Core with DocKimbles MySQL scheme;
>> system/version
== 2.5.5.3.1
>> do %listsql2.r
Script: "Untitled" (none)
Script: "mySQL Protocol" (25-Jul-2001)
mySQL protocol loaded
connecting to: wench
SQL database openned.
>> databaseinit
Initialised vw1...
Initialised vw2...
Initialised vw3...
Initialised vw4...
0:00:00.03
>> importcsvall
** Script Error: importcsvall has no value
** Near: importcsvall
>> importallcsv
0:00:00.751
Errr.... That's 117 times faster than REBOL/Command.
*Madness* Still, problem solved! :)
Regards,
Mat Bettinson - +44-(0)20-83401514.