How to limit connection in database

[alagukannan]

Hi,
I have a CFM Page with 2 queries,I need to limit the no of connections
established to the database server..has it crashes by servers.Is there a way i
can limit the no of times a viewer views a page.
I tried limiting the connection in the Datasource as well as cachedwithin .No
use

I need something like a user is shown a cached paged from the server...and
updates whenever the database updates.

Thx
AL

[hlevin]

Al,

consider storing the results of the query in the session scope then do <cfif
NOT isDefined()><cfquery></cfif>. this alone however will not force a re-query
when data changes. But it will deffinitely reduce the load on the database. You
could do the same in the application scope. I am surprised the cachedwithin
didn't solve your problem, it should have cached your query in server memory.

Henry