ASP.NET performance with PGSQL

Question

I have a c# asp.net app that connects to local databases using port forwarding. Depending on the local users upload speed this can make it really slow. Is there anyway (other than limiting the databases transactions which we are doing) of making this whole process run quicker. What database architecutre would help etc. I'm a bit of a beginner with this so i would appreciate any help you can offer.

The answer below is great!! The other thing that would really help if any one else cares is asp.net and html5 storage stephenwalther.com/blog/archive/2011/01/12/… — Daniel Casserly
– Daniel Casserly, Commented Jan 18, 2012 at 21:02

Pavel Stehule · Accepted Answer · 2012-01-18 07:49:29Z

2

npgsql can do pooling - http://npgsql.projects.postgresql.org/docs/manual/UserManual.html. Maybe pgBouncer helps to you. http://pgfoundry.org/projects/pgbouncer

answered Jan 18, 2012 at 7:49

Pavel Stehule

46.7k6 gold badges104 silver badges103 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Daniel Casserly Over a year ago

Cool that will certainly help. Does connection pooling make each transaction quicker? Is this almost as good as caching results (i imagine using the two strategies side by side is the best)

Collectives™ on Stack Overflow

ASP.NET performance with PGSQL

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related