Web Development

View All Threads First Prev Next

Database connection pool thr application anishkannan2-Apr-12 21:31 anishkannan 2-Apr-12 21:31  Hi... In my web application, we are using oracle database. my question is connection pool based on web application. Our application end user around 500. for these which connection is better i) create new connection for every request of user. ii) single connection pool via singleton object of the class iii) session based connection pool ( each user has separate connection pool) which principle is using for web application? can please give suggestion or valuable link to me --Thanks Re: Database connection pool thr application R. Giskard Reventlov5-Apr-12 6:43 R. Giskard Reventlov 5-Apr-12 6:43  This might be useful: ADO.NET Connection Pooling at a Glance[^]. "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me Re: Database connection pool thr application creditmesh17-May-12 23:32 creditmesh 17-May-12 23:32  If you get a lot of people connecting. Specfic pool for specfic guy is not an good thing because it whould cost too expensive resource usage. The ideal solution is one link conducting many database links. In my project. One or serveral thread are only conducting database connecting and sql processsing. When finished the sql it will send data to others.

Last Visit: 31-Dec-99 18:00     Last Update: 5-May-24 8:41 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.