Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

[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.