<br><font size=2 face="sans-serif">Hi Pierre,</font>
<br>
<br><font size=2 face="sans-serif">Thanks for answering my other questions. Just one more question, based on your answer to Alex.</font>
<br>
<br><font size=2 face="sans-serif">I had a quick look in the Metcard archives and found this snippet:</font>
<br><font size=2 face="sans-serif">>></font>
<br><font size=3 face="Courier New"><i>put "" into DbAuteurs<br>
get shell("echo" && quote & "select distinct auteur__ from citations order by<br>
auteur__" && quote && "| psql -h localhost citalis")<br>
repeat for each line l in line 3 to -3 of it<br>
put word 1 to -1 of l & return after DbAuteurs<br>
end repeat<br>
<<</i></font>
<br><font size=3 face="Courier New">This is more or less how I imagined you were shelling out to the psql interpreter. Am I correct in thinking this is how you are invoking postgresql?</font>
<br>
<br><font size=3 face="Courier New">I can understand Alex's disbelief in this regard. I share his understanding of how things are supposed to work using the combination the PHP Apache module, and persistent connections.</font>
<br>
<br><font size=3 face="Courier New">One of my apps is running on Linux and querying Firebird via ODBC. All the queries have configurable debug parameters, so I can actually change the parameter to time each step of the process. So I can isolate how long that app takes to connect and return a result set.</font>
<br>
<br><font size=3 face="Courier New">I will see if I can find some details on running Rev 2.01 as a command line application, and I will try to find some time next week to compare the speed of the two methods.</font>
<br><font size=3 face="Courier New"> </font>
<br>
<br><font size=3 face="Courier New">Bernard <i><br>
</i></font>
<br>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td>
<td><font size=1 face="sans-serif"><b>Pierre Sahores <psahores@easynet.fr></b></font>
<br><font size=1 face="sans-serif">Sent by: use-revolution-admin@lists.runrev.com</font>
<p><font size=1 face="sans-serif">13/07/2003 01:40</font>
<br><font size=1 face="sans-serif">Please respond to use-revolution</font>
<br>
<td><font size=1 face="Arial"> </font>
<br><font size=1 face="sans-serif"> To: "use-revolution@lists.runrev.com" <use-revolution@lists.runrev.com></font>
<br><font size=1 face="sans-serif"> cc: </font>
<br><font size=1 face="sans-serif"> Subject: Re: About MC/RR applications servers</font></table>
<br>
<br>
<br><font size=2 face="Courier New">On Sun, 2003-07-13 at 01:19, Alex Rice wrote:<br>
> On Saturday, July 12, 2003, at 04:56 PM, Pierre Sahores wrote:<br>
> ><br>
> > Just do tests and you will see as me that this works perfectly, faster<br>
> > for example, than in using ASP's or PHP commands, because the linux <br>
> > bash<br>
> > optimisations, because the psql perfect design to work in command-line<br>
> > pipe mode<br>
> <br>
> This doesn't make any sense to me. I would like to see the shell <br>
> command you are using.<br>
<br>
Hum... It's, even for you, freely, available on the Metacard archive<br>
list.<br>
> <br>
> You're saying what you are doing is faster than PHP direct to <br>
> PostgreSQL? PHP direct to PosgreSQL can have a persistent connection <br>
> already open, and PHP (as apache module) is running already in memory?!<br>
> <br>
> Your way: have to open a socket from PHP, launch the shell, then launch <br>
> the psql command line program, which THEN finally connects to the <br>
> database.<br>
<br>
Did you learn a little (aka lots) about WebSphere Weblogic or WebObjects<br>
before. Have you any idea about how applications servers works...<br>
> <br>
> It absolutely impossible that your way could be faster.<br>
<br>
Perhaps are you too sure of you about how unixes are handeling multiples<br>
processes tasks. Did you ever watch at the processor idle average time<br>
of a linux box ? To the end, you are not alone to think so... even if <br>
my clients are, probably, not only too rich and stupid persons...<br>
> <br>
> Again, why are you even using Revolution instead of just going from PHP <br>
> to PostgreSQL? Call me confused,<br>
<br>
Did you ever ask you about the difference it makes to use real<br>
application server instead of just including sql replies in web forms ?<br>
> <br>
> Alex Rice, Software Developer<br>
> Architectural Research Consultants, Inc.<br>
> http://ARCplanning.com<br>
> <br>
> _______________________________________________<br>
> use-revolution mailing list<br>
> use-revolution@lists.runrev.com<br>
> http://lists.runrev.com/mailman/listinfo/use-revolution<br>
-- <br>
Bien cordialement, Pierre Sahores<br>
<br>
Serveurs d'applications & bases ACID SQL<br>
Penser et produire l'avantage compétitif<br>
<br>
_______________________________________________<br>
use-revolution mailing list<br>
use-revolution@lists.runrev.com<br>
http://lists.runrev.com/mailman/listinfo/use-revolution<br>
<br>
</font>
<br>
<br>