i am working with VB and postgresql using ODBC. when i am running a query from pgadmin, the result came without any delay. but when i issuew the same query from VB with ODBC it is slow.(takes almost 1min.) what may be the problem. is there any thing to be set in the odbc configuration screen. what all are the meanings of so many options in the odbc configuration window. where can i get more information about each parameter settings.
What are u working with to interface your queries, in the Pgsl ODBC site there's a good example of how to use Pgsql ODBC , I am working with that ODBC with VB and ADO and it's going fast very fast , u should also update your odbc if it's old !
Really slow architecture , you'll need to update the Jet engine to get faster , or just get win2000 it's better ! the lastedt ODBC is about a week back age , I was just going evrybody to update he's driiver you can get it heue => http://gborg.postgresql.org/project/...rojdisplay.php