CFMX hangs. I have a page on my site that takes more than 1000ms
to return (runs about 10 big queries). If I get on this page and
hit F5 over and over again, I can see jrun.exe memory size and
thread count expand. The memory size never is the issue -- it's
the thread count. When it goes over 100, it seems like the
machine hangs. Eventually, it does respond, but while it's
hanging, the site is cooked.
So here's my question:
Is it possible for me to wrap a CFLOCK around that entire page,
to isolate it to a single thread? It isn't an often-visited
page, so I could probably get away with this.
Eventually, I'll need break up the query/page...looks like I'll
have to do this. Oh, and by the way, whenever I use JDBC
drivers, this issue is far worse...so I use ODBC Socket for
everything. My setup is Win2K on a dual pentium 5 with 2GB RAM
and SQL 7.0. Thanks!
- Sung
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
