Naomi,
I know you don't want to hear this, but honestly increasing the memory is probably a good idea. On your enduser's system, is it installed locally or on a server? If it's on a server, what sort of network do they have? What about the server? Are they running any other applications from that server (assuming they have one) and what is the performance like for those applications?
On the complicated form you described, how do you open data? Do you have USE commands in the LOAD event or are you using the data environment?
You mentioned that you have lots of tables and views. Do you have a lot of complex joins or filters in those views? Sometimes a strategically placed index can make all the difference in the world. Think Rushmore optimization when you look at your views.
Good Luck,
-Don
>>Naomi,
>>
>>Can you tell us a little more about the application? Like what size tables are you working with? Are their certain portions of the application that are slower than others, if so where is it the worst? Any 3rd Part controls?
>>
>>The other thing I've seen is user exageration. You send something to a user and they say wow this thing is really slow. Than you ask them well how long does it take...hmm I don't know... When you actually measure it the time is a few seconds. Not a bad idea to measure how long a certain procedure takes on your development machine and then measure on their machine to compare.
>>
>>-Don
>
>Hi Don,
>
>Thanks a lot for your reply. I went to user's machine and saw this slowness myself. I would say, it was dog slow :( The worse was opening of one quite complicated form with lots of biz objects and multiple pages (though now all pages are containers, so only one container is loaded in a time).
>
>The database has lots of tables and views, the main table has ~700000 records.
>
>The user doesn't have much read and write permissiones, so that could be another problem.
>
>Also I get some strange problems, like one of my library is not found in CreateControl method. The library is indeed included into the project.
