>Yes, the skill used in constructing a SQL has everything to do with speed.

I've noticed that to be true when using VFP, Oracle, PostgreSQL or any other SQL database. Oracle and PostgreSQL give an advantage over SQL in the richness of their allowed nested phrases.

> I've considered the possiblity that someone could use the VFP client I have made available to select all records from the testorders table. If there were 50,000 or 250,000 records, I assume my system would send all of them. This could slow my web/mail server down to a crawl.
>I think I will manage this by keeping the testorders table to a reasonable size, deleting records if need be, and run my performance test on another table.

You can LIMIT the number of rows a select returns by using the LIMIT clause.
I was looking for a config setting that would set a limit to the number of rows returned from a query, but I couldn't find one. I may be possible to write a function or trigger to intercept the query and append a LIMIT clause if the query doesn't have one.
JLK


>I spent this morning in the AdminphpPg administrator's app trying to work out a security scheme that make everything in the vfp2pg database available to the world at large while protecting everything else from harm.
>
>Time from Lunch. I'll check back later. Still have finished those returns from yesterday, but they have been electronically transmitted. Now I need to print/assemble the client's and my copies.