Form takes 15-20 minutes to load (info 2k3)

[Hemant]

hi.

I have one form with lot of things to display in it and and to update the
DB.Its physical size is 775kb.
It takes lot of time to load.
Many times it takes 15-20 minutes to just open.

The data which is being displayed and edited is mandatory to be in one form.
The data is sent back to DB server using Web Service Software Factory.

Also please tell me how can i maintain concurrency if i try to seperate the
big form in to smaller ones.

Please provide some solution.
I really dont understand what to do.

 

[Clay Fox]

This would be due to a large amount of data that is being loaded into your
form. If you have multiple views which display this data that will
contribute as well.

You need to use queries in your web service to reduce the data that is
loaded into the form.

Typically your form should load without much default data. The user selects
the record, the name, the date, etc and then the form queries the data source
and just that record is returned which typically performs fairly good.

If you need a web service which can do dynamic queries let me know.

I would have to know your data structure whether multiple forms would help
or not, typically one form is best if the data is related.