Stan's slow problem [located?]

[Ruslan Zasukhin]

On 5/31/06 10:20 PM, "Stan Busk" <maxprog at mac.com> wrote:

Hi Stan,

Okay, I was able to use Apple's Performance Tools to see where is problem in
your case.

With that Country Rating.

I see that is called

    Find_NotIndexed         94% of time !!!!
    FindValue

I.e. You should see about 20 times slow down, right ?

And reason is that you do something as

    WHERE fld = xxx

Where fld field is not indexed.

Hmm, not clear why 2.2 is fast for you ...


--------------------
I recommend you download and install V4RB 2.4 b10
Then try to use new feature EXPLAIN.

For this before do your SQL query you need turn ON
The WARNING mode. To do this you need simply add one line:

    db.SqlExecute( "SET PROPERTY WarningMode TO TRUE" )

    db.SqlExecute( your query )


Now after your query done, go to your app folder
You should see Warnings_log. Open it
Here you should see very detailed info about each step of query.

I expect that you will see WHICH field do that not indexed search.

Let me know result.

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