[REBOL] Re: mySQL driver for /Core
From: gjones05:mail:orion at: 10-Feb-2001 22:42
From: "Petr Krenzelok"
> Now it will be interesting to see the speed comparison between PHP Apache
> module and CGI script based mySQL protocol. Could anyone test it, please?
I
> am just curious, nothing more :-)
>
> Well, time to search some very old archive of Rebol/Apache core probably
:-)
> Cheers,
> -pekr-
Hi, Petr and all,
I hadn't realized how rusty my SQL skills had grown until I began tinkering
with MySQL.
First, let me say that working with MySQL through DocKimbel's protocol and
REBOL has been a pleasure. When I compared what I had to do under PHP, it
was a dream come true.
I have a 500 mhz de-Celeron with 128 MB RAM. I am running Windows 98,
Apache 1.3.14 running on localhost (still considered beta on Windows), MySQL
3.23.24 running as mysqld on localhost (still considered beta on Windows),
PHP 4.0.4 running as a module under Apache, REBOL 0.10.38.3.1 and 2.3.0.3.1
I didn't have any readily accessible large database available for my first
day of testing. So I converted what I consider a fairly small 905 record
database that had two text fields into a single table in a MySQL database.
I didn't configure an index for this first run. I created a SELECT on this
table looking for a phrase in the second field with wildcards at either end.
Since the database was so small, I looped my testing for 100 loops so that I
could get some times.
Under REBOL/View from the command prompt, with an open connection, the 100
loop cycle ran about 6-7 seconds. Running it with a new connection for each
iteration, the total time was about 8-9 seconds. Running a similar script
as a cgi script (this time under REBOL 2.3.0.3.1), the 100 loop iteration
took about 8 seconds when a new connection was made with each iteration.
When the connection was left open, it took 2 seconds. A php script
(assuming a did it correctly) took about 3 seconds with a connection that
was left open.
Let me reiterate that I am no expert in SQL, REBOL, PHP, or database
testing, but I am very impressed with the performance of MySQL used through
REBOL and DocKimbel's wonderful scheme. But when I consider usability, the
REBOL-way was vastly superior to PHP. Now, whether there would be an
additional performance boast with mod_rebol or FastCGI and REBOL, I don't
know. I would assume so. But the performance is already pretty good, at
least in my opinion.
Great job, DocKimbel!!!!
--Scott
