>Hi Hilmar
>
>I think you meant server do all the heavy work ;)
Yes, of course. My apologies, for not reviewing some messages carefully enough.
Hilmar.
>>File server (stores standard VPF DBF files): The client machine has to get all information required from the index - the entire index if your query and indices are badly designed (see my FAQ on Rushmore). Then, it has to get the records. If you want only the total (GROUP BY) all required records still have to be copied over the network. Even stored procedures are executed on the client machine.
>>
>>Database server (client-server, like Oracle, SQL Server, MySQL, etc.): It is at least possible to have the
server do all the heavy work, and return only the result over the network. A badly-designed system can still cause too much network traffic. But stored procedures are executed on the server.
>>
>>HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)