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.
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.
answered 17 Jan '13, 07:59
if your datawindow has text or column background colors that change based on data, it can be VERY slow to render and to scroll.
answered 17 Jan '13, 07:36
PowerBuilder 7 with SQLAnywhere 8? Those were both released about 12 or 13 years ago... And you wonder why your queries are slow?
answered 17 Jan '13, 16:11