It sounds like the "maintain DB connection" is not really working.
Are you using the Oracle ODBC drivers, or M$?? I had better luck
with the Oracle Drivers.
You also may need to reboot to get the "maintain connections" thing
to work.
There is also a DB timeout period to look at (I am using Ent) that
may be affecting you.
HTH,
Steve
At 07:18 PM 4/5/2000 -0400, Lomvardias, Christopher wrote:
>Every time I run a template that hits an Oracle 8i datasource via ODBC, the
>first query in the template takes about 350ms, even if I reload the page
>several times in quick succession. I've also tried it with the "Maintain
>Database Connections" checked and unchecked in the CF Admin with no effect.
>I've even tried using several different queries as the first query on the
>template, but again the first query always takes about 350ms even if I'm
>only grabbing one record.
>
>Does anyone know if this is something I'm going to have to live with or is
>there some way I can reduce the time on the first query on a page? As a side
>note, this app has to use CF Pro, so using the Oracle native driver isn't an
>option.
>
>Any suggestions would be greatly appreciated!
>
>Thanks,
>
>Chris
>------------------------------------------------------------------
>Chris Lomvardias
>[EMAIL PROTECTED]
>Syscom, Inc.
>400 E. Pratt Street, Suite 300
>Baltimore, MD 21202
>(410)539-3737 x1722 voice
>(410)539-7302 fax
>[EMAIL PROTECTED] (pager via email)
>http://www.syscom-inc.com/
>------------------------------------------------------------------
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
