Slow query in powerbuilder vs. isql

[former_SQLA_member1694915]

Dear sir,

i am working on powerbuilder 7 with ianywhere 8 i have problem when i put query in isql session it 's run so fast but when i load it under datawindow become so slow and my data not big.anyone can help me.

Thanks in advance.

[Former Member]

PowerBuilder 7 with SQLAnywhere 8? Those were both released about 12 or 13 years ago... And you wonder why your queries are slow?

-Paul Horan-

[Former Member]

ASA 8 was a very good release. And it's not so old. So depending on queries it may be not worst in performance compare to the current one.

[Former Member]

thaerlb,

How many records your select is returning?

Below can be a reason: In isql you "see" a result when first portion of records are fetched (by default something like 500 or less). In datawindow (often) you may "see" a result when all records are fetched to datawindow.

So if your select returns some XXX number of records, i.e. 10000 or 20000 records, then you will fill that difference is big. To check - go to isql , menu Option and look there must be tab RESULT. There is limitation, how many records are fetched by default. You may select "all" records and then see - is it still fast with isql or not.

[former_SQLA_member1694915]

Thanks sir it's running good i tried to delete data from system tables in database and now it's ok

[t1950]

if your datawindow has text or column background colors that change based on data, it can be VERY slow to render and to scroll.