Hi all,
Our database cursors are based on local views. We've been very satisfied to them in principle, but now we've met serious problems in network installations when the amount of data is big enough (in this specific case 10000 records). I've tried to squeeze my view and improve the situation by all possible ways and but without any bigger success so far.
At the end I just made a test where I fetched records first directly from table and then thru my local view and I was very astonished of the results. When I used table directly by 'use' and 'browse' commands, the fetching time was max. 5 seconds, but when I changed to a filttered view (only one field and one record) and gave to it same commands the time increased into several minutes.
Based on my test results I came to a conclusion that the view is fetching all records from underlaying table despite of it's own (restricted) sql-clause. If it's really so, is there any way to go around the problem? As you surely guess, direct use of tables is out of question.
Regards,
Ilkka