Re: [SQL] How to improve PgSql Performance using npgsql

2008-12-24 Thread Hilco Wijbenga
2008/12/24 Venkat Rao Tammineni : > try > { > pgSqlConnection.Open(); > } > catch (Exception exp) > {} I don't think you've really given enough information for anyone to answer your question but at the very least you sho

[SQL] How to improve PgSql Performance using npgsql

2008-12-24 Thread Venkat Rao Tammineni
Dear All, I am using npgsql.dll to connect postgresql database. Everything is working fine.but sometimes database is getting slow and even sometimes I am not getting data .I have written one function which access the data . Below is my code .. public NpgsqlConnection PgSqlDataCon