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

[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?
> 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 and 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, 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