[PERFORM] Result Set over Network Question

2012-05-03 Thread Ronald Hahn, DOCFOCUS INC.
Hi, We have recently switch our product from MS SQL 2000 to Postgresql 9.0.7. We have tuned the searches and indexes so that they are very close (often better) to what sql2k was giving us. We are noticing some differences now in the time it takes for the result set to make it back to the

Re: [PERFORM] Result Set over Network Question

2012-05-03 Thread Ronald Hahn, DOCFOCUS INC.
After some testing using wiershark (poor mans profiler) to see what was going on with the network I found that it was the tools I've been using. Both Aqua and PGadminIII have a large overhead per column to get the meta data. MSSQL sends that data upfront so the impact isn't as bad. I'm not sure