CFMX Hanging Solutions?

[Sung Woo]

I've been scouring the forums here and on Macromedia regarding 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!

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---