Thomas,
I will check this out using your guidelines. Will get back to all of you and the rest. Thanks.
Weird though, how come it works if it's a few thousand recs, but freezes up on its current levels (90,000)? Client reported that the time it takes to load the concerned forms increases as they went on, from minutes to HOURS(!), till the other day, when it really freezed up.
Dennis
>>What does 1=0 do? How come when I use SPT it works, like this:
>>
>>= SQLEXEC( gnDataSource, "SELECT * FROM parcel WHERE JobOrderID=<somevalue>"
>>
>
>If the above works well enough I am pretty sure there is something different in your specific CA class.
>If you connect through the same gnDataSource, you could manually fix/check the SelectCmd in the BeforeCursorfill() HookMethod
>(typing without checking the actual method names, but the parameters are all reference ones - you cannot miss it)
>One other thing: make sure there is a corresponding index on the MySql-Backend for the JobOrderID column
>(but even that should not take hours, more like minutes....)
>
>Build and Query your CA from the Command window with only one or two colums and perhaps
>a smaller copy of that table for test reasons - the before and after hookmethods give you excellent points to
>log duration, statement used, No. of records returned and so on. This is data as well ;-)
>
>HTH
>
>thomas