473,322 Members | 1,538 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Form Optimization

ken
Hi,
I have a form with a lot of subforms. This thing takes about 70 seconds
to load on a server. I have a front-end back-end set up in Access
2000/2003. Anyhow I tried to optimize the darn thing. I opened up half
of the forms on form open, and the other half open when the user clicks
on a (tab button). After I relink tables the first part of the form
takes about a minute to open. Then the second part takes about 20
seconds. Then I close database. Reopen it and the first form opens
intantly, and the second takes about 5 seconds. What's more interesting
is that when I take the front end and put it on another PC, the same
thing happens(it opens very fast). Then if I relink tables, again the
first time I open the forms it takes a long time...then fast again.
Anyone have any clue as to why this is?

Thanks in advance.

Nov 13 '05 #1
5 1775

ken wrote:
Hi,
I have a form with a lot of subforms. This thing takes about 70 seconds
to load on a server. I have a front-end back-end set up in Access
2000/2003. Anyhow I tried to optimize the darn thing. I opened up half
of the forms on form open, and the other half open when the user clicks
on a (tab button). After I relink tables the first part of the form
takes about a minute to open. Then the second part takes about 20
seconds. Then I close database. Reopen it and the first form opens
intantly, and the second takes about 5 seconds. What's more interesting
is that when I take the front end and put it on another PC, the same
thing happens(it opens very fast). Then if I relink tables, again the
first time I open the forms it takes a long time...then fast again.
Anyone have any clue as to why this is?

Thanks in advance.


Do you use the Form.Current event much? A while back I had a lot of
trouble with a slow-loading form with three sub-forms and it wasn't
until I stepped through the code that I realised it was calling the
Form.Current event many times. Can't remember why, though, or what I
did about it ;¬}

Edward

Nov 13 '05 #2
ken
no it goes in the form.current even once.

Nov 13 '05 #3
On 28 Oct 2005 06:14:18 -0700, "ken" <ge****@gmail.com> wrote:
Hi,
I have a form with a lot of subforms. This thing takes about 70 seconds
to load on a server. I have a front-end back-end set up in Access
2000/2003. Anyhow I tried to optimize the darn thing. I opened up half
of the forms on form open, and the other half open when the user clicks
on a (tab button). After I relink tables the first part of the form
takes about a minute to open. Then the second part takes about 20
seconds. Then I close database. Reopen it and the first form opens
intantly, and the second takes about 5 seconds. What's more interesting
is that when I take the front end and put it on another PC, the same
thing happens(it opens very fast). Then if I relink tables, again the
first time I open the forms it takes a long time...then fast again.
Anyone have any clue as to why this is?

Thanks in advance.


It sounds like the query plans for your queries are getting dropped when you
re-link, then rebuilt the first time the queries are executed. Does the
slow-down occur after a compact/repair of the front-end as well as after
relinking?
Nov 13 '05 #4
ken
YEP! I did a compact repair and it was slow again. Anyway I can prevent
query plans from getting dropped? I tried this in an uncompiled file.
If I use an MDE will I get the same thing after compact/repair?

Nov 13 '05 #5
Steve Jorgensen <no****@nospam.nospam> wrote in
news:l5********************************@4ax.com:
On 28 Oct 2005 06:14:18 -0700, "ken" <ge****@gmail.com> wrote:
I have a form with a lot of subforms. This thing takes about 70
seconds to load on a server. I have a front-end back-end set up in
Access 2000/2003. Anyhow I tried to optimize the darn thing. I
opened up half of the forms on form open, and the other half open
when the user clicks on a (tab button). After I relink tables the
first part of the form takes about a minute to open. Then the
second part takes about 20 seconds. Then I close database. Reopen
it and the first form opens intantly, and the second takes about 5
seconds. What's more interesting is that when I take the front end
and put it on another PC, the same thing happens(it opens very
fast). Then if I relink tables, again the first time I open the
forms it takes a long time...then fast again. Anyone have any clue
as to why this is?


It sounds like the query plans for your queries are getting
dropped when you re-link, then rebuilt the first time the queries
are executed. Does the slow-down occur after a compact/repair of
the front-end as well as after relinking?


Well, there's also the issue of relinking not updating the stats
stored in the linked table definition. This is a problem A2K, and
when it strikes, it can be corrected by deleting and recreating the
links instead of just updating the connect string.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Noozer | last post by:
Below is some ASP, HTML and javascript. It is part of a page used to maintain a small database. This code did work at one time, but has since stopped. For some reason the data on my form is not...
3
by: Alex Vinokur | last post by:
For instance, we need to measure performance of assignment 'ch1 = ch2' where ch1 and ch2 are of char type. We need to do that for different optimization levels of the same compiler. Here is...
2
by: Eugene | last post by:
I am trying to set query optimization class in a simple SQL UDF like this: CREATE FUNCTION udftest ( in_item_id INT ) SPECIFIC udftest MODIFIES SQL DATA RETURNS TABLE( location_id INT,...
12
by: WantedToBeDBA | last post by:
Hi all, db2 => create table emp(empno int not null primary key, \ db2 (cont.) => sex char(1) not null constraint s_check check \ db2 (cont.) => (sex in ('m','f')) \ db2 (cont.) => not enforced...
3
by: John Welch | last post by:
I'm developing my first multi-user application, and have been reading a lot about the basics of multi-user optimization (ADH vol 2, this newsgroup's archives, etc.). I've decided to go with a file...
24
by: Kunal | last post by:
Hello, I need help in removing if ..else conditions inside for loops. I have used the following method but I am not sure whether it has actually helped. Below is an example to illustrate what I...
21
by: mjbackues at yahoo | last post by:
Hello. I'm having a problem with the Visual Studio .net (2003) C++ speed optimization, and hope someone can suggest a workaround. My project includes many C++ files, most of which work fine...
5
by: wkaras | last post by:
I've compiled this code: const int x0 = 10; const int x1 = 20; const int x2 = 30; int x = { x2, x0, x1 }; struct Y {
2
by: db2admin | last post by:
hi, I have query which runs great when optimization level is changed to 3 but does not run fine with default optimization level of 5. since this is a query in java code, i do not know how can i...
20
by: Ravikiran | last post by:
Hi Friends, I wanted know about whatt is ment by zero optimization and sign optimization and its differences.... Thank you...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.