<br><font size=2 face="Courier New">Thanks Pierre</font>
<br>
<br><font size=2 face="Courier New">>></font>
<br><font size=2 face="Courier New">Just do tests and you will see as me that this works perfectly, faster</font>
<br><font size=2 face="Courier New">for example, than in using ASP's or PHP commands, because the linux bash</font>
<br><font size=2 face="Courier New">optimisations, because the psql perfect design to work in command-line</font>
<br><font size=2 face="Courier New">pipe mode.</font>
<br><font size=2 face="Courier New"><<</font>
<br><font size=2 face="Courier New">Well, this is rather flabberghasting...</font>
<br><font size=2 face="Courier New">I suppose it does fit in with the unix philosophy. I am prepared to believe you, and when I get the time I will try to do some comparisons for myself.</font>
<br>
<br><font size=2 face="Courier New">>></font>
<br><font size=2 face="Courier New">I just remplace all of them by metatalk/transcript calculations on very</font>
<br><font size=2 face="Courier New">simple SQL requests replies</font>
<br><font size=2 face="Courier New"><<</font>
<br><font size=2 face="Courier New">With regard to SPs, triggers, etc.. I still don't understand why you do not use them. Is it because they do not work, because they are slow, or because you just prefer to do it in Transcript?</font>
<br>
<br><font size=2 face="Courier New">>></font>
<br><font size=2 face="Courier New">75% of writes on databases going from some megs (events statistics) up</font>
<br><font size=2 face="Courier New">to 250 Megs of datas, with, as an average, no more than 10 Megs peer</font>
<br><font size=2 face="Courier New">table</font>
<br><font size=2 face="Courier New"><<</font>
<br><font size=2 face="Courier New">And it is basically a write-intensive application? </font>
<br><font size=2 face="Courier New">Do I understand correctly that each write can be several megabytes?</font>
<br><font size=2 face="Courier New">And that the database size is around 250mb?</font>
<br>
<br><font size=2 face="Courier New">>></font>
<br><font size=2 face="Courier New">Suse 8 Pro x86 - Athlon 800 1 Go Ram - server. All the other</font>
<br><font size=2 face="Courier New">apps are hosted on 3 st box, again Suse 8 Pro x86 - Athlon 800 1 Go Ram.</font>
<br><font size=2 face="Courier New"><<</font>
<br><font size=2 face="Courier New">Each server has 1gb of RAM? Do you find you need that much?</font>
<br><font size=2 face="Courier New">I suppose if your queries are write-intensive this extra RAM is not there to boost PostgreSQL's cache?</font>
<br>
<br><font size=2 face="Courier New">I'm in agreement about OS X being slow compared to Linux. Imagine running Linux on Panther :-)</font>
<br>
<br><font size=2 face="Courier New">Bernard </font>