r3wp [groups: 83 posts: 189283]
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

World: r3wp

[All] except covered in other channels

[unknown: 5]
18-Jan-2005
[687x2]
The utility probably has an option to clear its configuration
Just remember this.  That is usually write a config to the disk itself. 
 This is how it knows what slot or position the drive is even if 
you move them around.  But the NVRAM is on the card and usually backed 
up by battery power to retain the configuration (you need to blow 
that away).
Graham
18-Jan-2005
[689]
no battery so I'll just remove the card.
[unknown: 5]
18-Jan-2005
[690x3]
Hmm..
Ahhh that one has an (optional) battery module.
That means it completely using the config of the drive and thats 
why it detects it automatically as a volume.  You most likely wont 
be able to change that then without a special tool from them since 
you would need to force a write to the drive config to show that 
its drive 0 of array 0.
Graham
18-Jan-2005
[693]
I'll see if I can see if they have some tools I can download.
[unknown: 5]
18-Jan-2005
[694x2]
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.
Graham
18-Jan-2005
[696]
I posted yesterday morning and nothing so far.
[unknown: 5]
18-Jan-2005
[697]
We need Selma back.  Selma was better than this.
Graham
18-Jan-2005
[698]
It may not be ecartis but their mail server that is the problem.
Sunanda
18-Jan-2005
[699]
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
Graham
18-Jan-2005
[700]
my message reached the list at http://mail.rebol.net/cgi-bin/mail-list.r
but didn't get out again back to me.
Sunanda
18-Jan-2005
[701]
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.
[unknown: 5]
19-Jan-2005
[702]
Anyone have rebol highlight files for PSPad?
Graham
22-Jan-2005
[703x2]
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.
Terry
22-Jan-2005
[705]
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?
Graham
22-Jan-2005
[706x2]
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.
Terry
22-Jan-2005
[708x2]
But if you want to access a mysql server, the cgi script loads each 
time, right?
loads the mysql protocol, that is.
Graham
22-Jan-2005
[710]
depends on how it is written.
Terry
22-Jan-2005
[711]
can you give me an example of a cgi script that access a db, and 
doesn't load the protocol each time?
Graham
22-Jan-2005
[712]
any Zope cgi script that access a database does that.
Terry
22-Jan-2005
[713]
I'm referring to Rebol
Graham
22-Jan-2005
[714]
if I have a rebol daemon running that has a connection to a odbc 
database, then my rebol cgi script an interact with that.
Terry
22-Jan-2005
[715]
via what, tcp?
Graham
22-Jan-2005
[716]
yes
Terry
22-Jan-2005
[717]
Well, I wonder what has less overhead.. reading a 23kb protocol with 
each call, or taking the time to do a tcp call?
Graham
22-Jan-2005
[718x2]
clearly the latter
my portal does this .. keeps an open sql connection which is used 
by incoming requests
Terry
22-Jan-2005
[720]
what do you use, rugby?
Graham
22-Jan-2005
[721]
yes.
Terry
22-Jan-2005
[722]
What is faster, reading a 100 byte text file, or accessing 100 bytes 
from a DB?
Graham
22-Jan-2005
[723]
you would have to do timing studies on questions like this ...
Terry
22-Jan-2005
[724]
Yeah, just doing that now.
Graham
22-Jan-2005
[725x3]
after a text file being read from a directory is another db operation.
after all ..
the filing system is a database
Terry
22-Jan-2005
[728x4]
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.
Graham
22-Jan-2005
[732]
are you waiting for responses before you call it again?
Terry
22-Jan-2005
[733x2]
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.
Graham
22-Jan-2005
[735]
and if you have 1million files in the local directory?
Terry
22-Jan-2005
[736]
good question... and one million files in the DB as well.