Stan's slow problem

[Stan Busk]

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. 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. 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.

Again, I know, a lot of bla bla bla and you want a database... I just  
need to figure out how to do that the best so you can see what I am  
talking about. I also need to choose what app to use for that as  
absolutely all have the same symptoms.

Stan

> On 5/27/06 12:44 PM, "Stan Busk" <maxprog at mac.com> wrote:
>
>> I personally think Valentina 2.3 has a serious speed problem with
>> COUNT() and SUM() functions. As soon as you revert to Valentina v2.2,
>> it works at normal speed again. So my question is, what happened
>> between v2.2 and v2.3 that could affect COUNT() and SUM() ? Right now
>> it is faster for me to count and sum manually with a for...next.
>>
>> I have the problem in 3 different projects with about 30 queries
>> using COUNT() and SUM() functions. Could you compare v2.2 and v2.3
>> speed for those functions?
>
> Stan,
>
> I have take the same Examples/1.x/Single Table example,
> Table 100K records.
>
> Query
>
> select count(*)
> from Person
> where byte_fld < 100
> order by byte_fld
>
> Return result fast.
> WHERE condition of this query select 37000 records..
> So quite big result and many work for COUNT(*)
>
> I have try modify query to be
>
> select sum(byte_fld)
> from Person
> where byte_fld > 1
> order by byte_fld
>
> Again no time ....
> Stan, I cannot reproduce your problem here with all my best.
>
> -----------
> I cannot understand, why few weeks you complain on speed,
> but have send me NOTHING so far ???
>
>
> -- 
> 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]
>
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta