As a test, I ran a query in the pgAdmin query tool, which returns about 15K records from a PostgreSQL v8.01 table on my Win2K server. I ran the same query from the local server, from another PC on the same 100 mbit local network, and from a PC on a different network, over the internet. The times for the query to run and the data to return for each of the three locations are shown here:
1 : 2.43 : 7.71 whereas the query execution time ratios are: 1 : 2.08 : 25.5 (!!!) Obviously, the transport times will be greater. But why does the execution time bloat so? |
- [PERFORM] Query performance Lou O'Quin
- Re: [PERFORM] Query performance Tom Lane
- Re: [PERFORM] Query performance Lou O'Quin
- Re: [PERFORM] Query performance Tom Lane
- Re: [PERFORM] Query performance Lou O'Quin