On Mar 18, 2010, at 5:45 PM, Baiss Eric Magnusson wrote:
| | | | | +-[1465.20ms / 29%] SQL (select): entity=Transaction,
qualifier=null, {rows=5611}
| | | | | | +-[72.50ms / 1%] SQL (evaluate): SELECT t0….(proprietary)
this is saying that 30% of your time is spent reading 6000 results
from
> | | | | | +-[1465.20ms / 29%] SQL (select): entity=Transaction,
> qualifier=null, {rows=5611}
> | | | | | | +-[72.50ms / 1%] SQL (evaluate): SELECT t0….(proprietary)
this is saying that 30% of your time is spent reading 6000 results from this
query .. .
1) that's a big result,
2) there are eit
On Mar 15, 2010, at 1:44 PM, Baiss Eric Magnusson wrote:
Hello Chuck and others, many thanks.
Here's my current status, I would be surprised to find out that it's
at least close to "as good as it gets", but that's where I stand now.
**
After my 1st abortive attempt at upg
> | | | | | +-[1465.20ms / 29%] SQL (select): entity=Transaction,
> qualifier=null, {rows=5611}
> | | | | | | +-[72.50ms / 1%] SQL (evaluate): SELECT t0….(proprietary)
this is saying that 30% of your time is spent reading 6000 results from this
query .. .1) that's a big result, 2) there are eithe
Hello Chuck and others, many thanks.
Here's my current status, I would be surprised to find out that it's at least
close to "as good as it gets", but that's where I stand now.
**
After my 1st abortive attempt at upgrading to FB5 from 4 I succeeded thanks to
Chuck's help with
> I am hoping to learn how to utilize the ERProfiling information I am now
> viewing.
>
> After the Main/Login page the Current Situation page comes up in 5000ms.
>
> Profiler: 5122.11ms; SQL: 52% (84); D2W: 0% (0); T/I/A: 0% / 85% / 14%
it says:
* your entire request took 5 seconds to process
*
On Mar 11, 2010, at 3:32 PM, Baiss Eric Magnusson wrote:
I am hoping to learn how to utilize the ERProfiling information I am
now viewing.
After the Main/Login page the Current Situation page comes up in
5000ms.
Profiler: 5122.11ms; SQL: 52% (84); D2W: 0% (0); T/I/A: 0% / 85% / 14%
Wher
I am hoping to learn how to utilize the ERProfiling information I am now
viewing.
After the Main/Login page the Current Situation page comes up in 5000ms.
Profiler: 5122.11ms; SQL: 52% (84); D2W: 0% (0); T/I/A: 0% / 85% / 14%
Where is the bottleneck?
I look with BBEdit at the SQL info from the
