>>>Hi all,
>>>
>>>I have a form with a pageframe on it with another pageframe on one of the tabs. On the secondary pageframe I have several textboxes and a dropdown list linking a vender table to the purchase order header file (which is the main workarea for all the textboxes). I've set the data environment to use pesimistic record locks. When I run this form 2 times the second instance runs extremely slow and seems unable to navigate all the records in the purchase order header file while the first instance appears tobe fine..... I'm sure I've done something stupid here but I can't fiqure out where I've gone wrong. I've reset the buffer mode and tried private data sessions but it didn't work. Can anybody out there give me some insight into this ?
>>>
>>
>>Does second instance run fast without buffering?
>>Did you set Form.BufferMode or DE.Cursor.BufferModeOverride ?
>
>Hi Ed,
>
>I changed a number of things but the second form runs slow. One of the first things I did was set the form's buffermode to Pesimistic and the tables to use the forms settings then turned everything off (none) and recompiled the form and ran 2 instances of it just to see what happens and still the second form ran slow. Can the temp. cursor (select into a cursor) on my secondary table be doing this, something's running continually on the second form ?
>
>Don

Obviously, buffering is not suspect anymore, so you may look at Select-SQL Rushmore. Also, do you provide select into different cursor alias running the second form, or you use private DS?