World: r3wp

I'll see if I can see if they have some tools I can download.

Good luck.  I know how frustrating that can be.

how long has the latency been running on the mailing list.  I posted 
earlier and my post still didn't show up.

I posted yesterday morning and nothing so far.

We need Selma back.  Selma was better than this.

It may not be ecartis but their mail server that is the problem.

Selma had her off days too:

http://www.rebol.org/cgi-bin/cgiwrap/rebol/ml-display-message.r?m=rmlHFFB
Or, as Graham suggests, it's RT's mail server

my message reached the list at http://mail.rebol.net/cgi-bin/mail-list.r
but didn't get out again back to me.

I lost one yesterday too, in the same way.

It all seemed to be working okay for a week or two, but is slipping 
again now.

Anyone have rebol highlight files for PSPad?

I'm playing around with mediawiki .. a great little wiki.  Even has 
preferences for your time zone so that you can see when edits were 
done according to your own local reference.

Would be great if such a wiki could be done using Magic.

I've questioned this a few times over the years now.. 

If we have a CGI script that uses the mysql protocol, is it necessary 
to load this protocol with every cgi request?  Wouldn't that add 
some burden to the server?

you probably have a pool of connections which are re-used

forinstance, in Zope, I have a single sql connection which is used 
by all the "cgi" requests.

But if you want to access a mysql server, the cgi script loads each 
time, right?

loads the mysql protocol, that is.

depends on how it is written.

can you give me an example of a cgi script that access a db, and 
doesn't load the protocol each time?

any Zope cgi script that access a database does that.

I'm referring to Rebol

if I have a rebol daemon running that has a connection to a odbc 
database, then my rebol cgi script an interact with that.

via what, tcp?

yes

Well, I wonder what has less overhead.. reading a 23kb protocol with 
each call, or taking the time to do a tcp call?

clearly the latter

my portal does this .. keeps an open sql connection which is used 
by incoming requests

what do you use, rugby?

yes.

What is faster, reading a 100 byte text file, or accessing 100 bytes 
from a DB?

you would have to do timing studies on questions like this ...

Yeah, just doing that now.

after a text file being read from a directory is another db operation.

after all ..

the filing system is a database

is it?

Ok, doing some timing tests.. using 10000 loops... 


Firstly, the mysql is choking around the 9800 -9850 mark by denying 
access at that point...

(i think my test code is messed up)

Actually, i was counting down, and mySQL is choking after 150 calls 
or so.

are you waiting for responses before you call it again?

Forced to reduce the number of iterations to 100 for mysql sake.. 
and even then it would choke 50% of the time.. results.. 


Reading the DB used mysql-protocol.r with join mysql://.. localhost 
{select email from table where name='name' }
Reading the file used a: load %file.txt, b: select a 'email
mysql - 1.35 seconds (using time/now/precise

file - 0 seconds (timestart - 18:35:25.531, timefinish - 18:35:25.531)


Conclusion.. no contest.. loading and selecting from file wins hands 
down.

Graham, if i need to wait for a response, then i would need to add 
that time to the total for mysql.

and if you have 1million files in the local directory?

good question... and one million files in the DB as well.

10000 iterations using the load file method.. 0:00:00.781

I doubt very much that the DB could do that.

and then later on if you need to copy the 1million files from the 
filing system, or copy the mysql database .. which is faster?

another good point.. think ill load up a directory with a few 100,000 
files and see what happens ;)

If you dont' here from me, you'll know that I mashed my drive :)

hear, that is