?
Solved

how to use databse connection pooling using MTS and ASP to speed up queries

Posted on 2003-02-20
5
Medium Priority
?
204 Views
Last Modified: 2010-03-17
I have oracle database. I have stored procedure also.
How to increase speed of query result using connection pooing usign MTS with ASP.

give me some code example.

IS ANY OTHER WAY TO SPEED UP EXECUTING QUERY APART FROM CONNECTION POOLING.
0
Comment
Question by:kjohn008
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
5 Comments
 
LVL 2

Accepted Solution

by:
sfotex earned 200 total points
ID: 7997516
Check out http://developer.java.sun.com/developer/onlineTraining/Programming/JDCBook/conpool.html for info on dbase design.


Beyond pooling, you can do things like caching info server side, profiling the dbase to see what queries are taking the longest, write/rewrite stored procs to return what you need/what your going to need...
0
 
LVL 2

Expert Comment

by:sfotex
ID: 7999468
here's another site with more info on pooling performance tips:
http://www.javaperformancetuning.com/tips/jdbcconnpool.shtml
0
 
LVL 2

Expert Comment

by:sfotex
ID: 7999748
here's another site with more info on pooling performance tips:
http://www.javaperformancetuning.com/tips/jdbcconnpool.shtml
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert websphere application server default chained Certificates from 1024 to 2048 keysize or higher size and also you can change signatureAlgorithm . Please make sure Websphere Application Server fixpack 7.0.0.23 or Above. The following steps a…
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question