Hi,
This is viswam.
Iam using PostgreSQL 9.1 in my local system.when iam using this database
with vb.net my application gets very slow while retriving data from
database.if i used the same with access or SQL database its is very fast.
Can i know what is the problem.Iam using ODBC Connection for postgresql.
here iam writing one sample table in postgresql.
CREATE TABLE "AppUsers"
(
"UserID" smallint,
"Name" character(100),
"EmailID" character(150),
"Password" character(20),
"UserRole" character(50)
)
WITH (
OIDS=FALSE
);
ALTER TABLE "AppUsers"
OWNER TO postgres;