• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 209
  • Last Modified:

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

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
kjohn008
Asked:
kjohn008
  • 3
1 Solution
 
sfotexCommented:
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
 
sfotexCommented:
here's another site with more info on pooling performance tips:
http://www.javaperformancetuning.com/tips/jdbcconnpool.shtml
0
 
sfotexCommented:
here's another site with more info on pooling performance tips:
http://www.javaperformancetuning.com/tips/jdbcconnpool.shtml
0

Featured Post

Managing Security & Risk at the Speed of Business

Gartner Research VP, Neil McDonald & AlgoSec CTO, Prof. Avishai Wool, discuss the business-driven approach to automated security policy management, its benefits and how to align security policy management with business processes to address today's security challenges.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now