Hi,

I have a main form with 4 subform. Each subfrom is connected to query. When i open the main form and enter the data , the subform will show the data based on the main form. But it is very slow. How i can make it fast? My DB is divided into FE and BE. So if i split BE tables in to may BE database and link it to FE is it possible to make it fast? or any other method?
How i can solve this issue? Any Help?

waseem

Speed issues can be cause by a huge number of things, Service packs are one thing to look out for, updating them can drastically increase speed as they can optimize the JET engine. It is far more likely however to be the design of your forms or queries.

Open each of your queries the forms are based on and see how fast they run (bear in mind that if each loads in about 2 seconds that might not seem bad, but when you multiple it 4 times you get 8 seconds), if they run slowly you need to look into optimizing your queries, in particular check that you have appropriate indexes, that can make a huge difference. If there is no speed issue there it might be other content on your forms, do you have many graphics on there?

I am sure there are many other suggestions people have but you need to do some investigating to narrow down the speed issue before we can help.

Jon

Do you have any calculations or any domain functions (dlookup, dcount,dsum) in the queries?

Do you have all the tables set up in proper relationship, with the primary key of the mainform being the foreign key of each subform?

Did you combine anything with union queries?

Dear Milton,


In 2 subforms , i have separate 2 union queries which combines 2 queries. I didn't prepare tables with relation ship. There is calculation on main form. So is it create slowness?


Dear John
if i open subforms separately it opens fast. But with main form only it takes time

waseem

Are you bearing in mind the combined load time I mentioned? Also try making a copy of the Main Form (or backing it up and using the original to avoid any naming issues) and try running it without the 4 subforms, see if it still runs slowly without them.

Hi,

I removed the subforms. Then Main form works very fast. So what is the reason then?How i can solve this issue?

waseem

Got me stumped at this point, any chance of an upload?

Hi,

if i split the db in to different db 's , is there any help to speed up?


waseem

Hi,

I have code on main form .. On activate()

Me.SUBFRMTOTPAYMENTS.Requery
Me.STOTFEEBALANCESUBFRM.Requery
Me.STOTTRANSBALANCESUBFORM.Requery
Me.Subfrmchqonhold.Requery


May be this creates slow ness. Because when we open the other form from comand button and close after finishing on that form,the main form activates.When main form activates , it requery 4 subforms on main form. Is there any other method or code which can make this faster.




Regards,

Waseem