Hello friends,
I use some complex (Time Consuming) views which use to extract data from some thousands of records for my reporting purpose.
I used to load these views with my main form in its database environment.
Through the phases, i noticed that certain reports are not often used by my client so i thought to remove these views from the database environment and load them whenever they are necessary.
Hence some views were removed from my database environment.But to my disappointment, that there should be an increase in speed of the main form loading, it didn't show me any difference.
Example
1.My main form takes 25 seconds to load(Long Time) which has a view name 'VIEW1'
2.View1 takes 15 seconds in requery
After removal of VIEW1 from main form, main form should take less than 25 seconds, but i found no difference.
Why so?
Is it that views are not loaded with the database environment?
Thanks
Aashish