What's the database?
While most db's will not allow multiple selects in simple jdbc requests
(i.e. CFQUERY tag), some will allow multiple selects (and return
multiple result sets, way fast) when compiled into a stored procedure.
This raises the possibility of one humongous SP into which you pass ~100
parameters.
It's hard without knowing your specific app, but there are times when
you need to gauge which technology is best suited to perform the work.
In my case: I know ColdFusion better than anything else, which means
that I may use it to solve a problem - that the database could have
handled far more efficiently given a good SP. I can write them, It's
just not fun for me; so the application suffers for purely human reasons.
Sorry for not specifically answering your question. Perhaps some debug
output or verbose logging on the db side could answer your connection
theory?
Al Holden
--
Open BlueDragon Public Mailing List
http://www.openbluedragon.org/ http://twitter.com/OpenBlueDragon
mailing list - http://groups.google.com/group/openbd?hl=en
!! save a network - please trim replies before posting !!
