SQL in series

sabety · Post by **sabety** » Fri Dec 29, 2000 6:44 am

I have about 12 SQL statements in series pulling data from 3 separate tables (due to major differences in schemas). The results are displayed integrated on one html page.

The results are returned in a reasonable time, but not lightning fast. I have metamorph indexes and no linear searching allowed. I use the ROW statement to preserve memory, but it seems that most of the overhead is in switching from one SQL statement to the next. I can see the lag (in terms of bytes returned), in netscape, as it hops from one sql to the next. Any recommendations on fine-tuning this type of searching?

btw, Each sql statement is very fast if executed separately.

thanks
J. Sabety

sabety · Post by **sabety** » Tue Jan 02, 2001 3:35 am

Hi John

Thanks for the suggestions. I went back to my script and noticed that I goofed up. The first table I was searching was a small one which I allowed linear searching against! I failed to turn it off before resuming searching on the other tables. It is lightning fast now, even with 12 SQL statements!

bonne annee!

P.S. I know someone who remembers you from Ecole Internationale. He is actually my neighbour and I think he went there as well during your time. Small world...

Erik · Post by **Erik** » Wed Mar 14, 2001 9:52 am

Hi there,

Happened to come across this email as I was looking around for some technical info, and noticed a ref to the Ecole Internationale. Seeing as I went there myself, and did know a John Turnbull, was wondering if you are one and the same.

Cheers,
Erik Vought