On Oct 29, 2006, at 1:25 PM, Baiss Eric Magnusson wrote:
I have a long-standing problem with my main WO site <http://
www.Track-Your-Finances.com>, when I ask for a lot of records, say
(400-2000) and upwards.
This is a WO-Frontbase-MacOSXS site.
Something gets hung and I don't know what it is.
From Activity Monitor I see no sign of CPU saturation, there's
significant memory available, lots of disk space, and the Network
traffic is down to near zero.
Here's what TOP, from Monitor shows me, at a moment when a page hung:
This looks like you've asked it to sample for X seconds (top -s
<time>), but didn't give top enough time to do the sample. The clue
is the %CPU all 0.0%. Nevertheless, the other numbers are useful.
Definitely seems like you have enough RAM.
From my old embedded programming & real-time simulation days, it
appears to be like a port conflict where the system just hangs for
a very long period of time, say ten minutes.
This is my last big hurdle before I'm ready for a significant
launch...
Do you notice an increase in disk activity? Does the same query take
the same length of time if you run it twice in a row?
Have you narrowed down all possibilities so that you're sure the
delay comes between querying FB and getting a response back?
It might be the communication between FB and the app (they're on the
same machine, so no network activity will show up). The 2000 rows:
what's the average length of a row? I would expect a slowdown
returning only 100 rows -- if those rows were 10GB blobs...
