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;