Insert/Update delay in shared environment

[scaldwell]

I have a very simple page that display four pieces of information from a
database. This page allows the user to change this information and see the
results on the same page. Every so often a user submits the update succesfully
but when the page refreshes the old information is still visible. Is it
possible that there is a significant lag on the database server so that when
the select statement is sent again the new data is still begin processed?

I'm using CFMX 7 and Microsoft SQL Server 2000. This is an application hosted
in a shared environment (database and coldfusion). I've never experience the
problems, but I have users who have. This database server has about 100 other
databases on it along with mine.

It appears to be a performance problem on the backend. If anyone has any
thoughts they would be appreciated.

Thanks,

Scott

[paross1]

Could this be a query caching issue?

[scaldwell]

I'm not caching the query in my cfquery tag. In fact, I've never experience the
problem at all. I have had several users talk to me about it. It seems that
after 15 or 20 seconds the data is available.