Stan's slow problem

[Ruslan Zasukhin]

On 5/29/06 3:17 PM, "Stan Busk" <maxprog at mac.com> wrote:

> I will send you a database so you can test. I have the problem
> everywhere, in my 3 products and dozens of databases. Maybe it looks
> fast for you with one only query. My accounting product for example
> creates reports doing perhaps 100 queries in a loop. If one query
> takes 1s rather than 0.25, it takes now 4 times more. My management
> software also creates reports and charts. Charts were instantaneous
> before, now they take up to 20 seconds.

This should be easy to reproduce!
How many queries in loop do chart ?

    20 / 100 = 0.2 sec per query now.

    0.5 / 100 = 0.005 sec per query in 2.2

Have I correctly estimate times ?

> Again, I query the database  in a loop for all periods in the chart. If one
> query is slower and I  have 60 or 100 periods I have to wait a long time to
> get the chart  displayed.

So chart do about 60-100 loops ?

> In my newsreader, on startup I count articles per group,
> there are 80 groups, it takes a couple of seconds with v2.2 but more
> than 20 seconds on 2.3 likely because queries are slightly slower.

> When inside the application and I show threads with unread article
> count it takes far much longer to display, again because I do a lot
> of query, scrolling list it goes slower and slower until I get beach
> ball and have to wait for calculations to be done. With v2.2 that was
> instantaneous and working perfectly. So v2.3 has screwed all my
> projects without exceptions.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]