[pliff]

I got a proyecto in visual basic with postgres connected throw ODBC and ADO, now the database is nearly 15000 registers and the program it's getting to slow it's take like 4 seconds to execute a query, and from the pgadmin less than 0.5 seconds the same query, what can i do for that?

I'll apreciated your answers.

[amthomas]

hmm, there isn't much information here, but it sounds like the DB isn't the problem. I would look at the code and try to see where it is going slow and see if that is the problem.

If it is an issue with the ODBC/ADO stuff then I dunno sorry.

If it was the db causing issues then you could look at building indexes depending on what you are trying to do. But with only 15000 records (I am assuming that is what you meant) then I don't think that is your problem.

good luck!

[loquin]

I would suggest that you post the code you're using to connect to the database, as well as to declare, instanciate, and open the recordset.

[pliff]

This is the coneection string i use to connect, i have it in a function and i want call it for every adodc component.

ado.ConnectionString = "Provider=MSDASQL.1;Persist Security Info=False;User ID=postgres;Data Source=super"

[loquin]

Don't use ADODC. ADODC is bound to a very old version of ADO (v2.1, I believe - the latest version is 2.8...) ADODC adds another layer between the user and the database, and is less efficient than ADO. Also, ADODC opens a separate connection for every control by default.

Ref this ADO Tutorial at our VB sister site.