Hello,
I just split my database into front and back end. My front end users are experiencing really slow opening of forms. I've searched online for help speeding up forms, but I'm not sure what the best way is with my current setup. I've inherited the database from a previous programmer, and he set things up a little uniquely.
Here's the deal:
I have a main form that opens, listing in a subform all of the projects, with some top-level data. Double clicking on the record selector opens up the individual project form (frmProject). That's where it goes slow.
frmProject is an unbound form, and in the "on open" event, the VBA code calls a long list of methods that collects the data based off of the ProjectID, and dumps that data into the appropriate fields in frmProject.
I tried converting the front end to MDE, and it did speed things up a bit, but still too slow.
Since I split the database and linked the front end to the back end tables, things have gotten really slow. The back end is placed on: L:\Translation Unit\Backend.md b, and the frontend is palced on: L:\Translation Unit\Front\Fron tend.mdb.
Any ideas?
5  1426 
How many users are using this application? (I had the same problem a while back)
From what I have read, the front end is to be on the local drive ie the c:\ drive. Could it be that with the front and back been on the same drive it would slow it down?
You havent said what operating system you are using so this is something of a guess.
I imagine that durng the Form Load event the links between the front end and back end are set or refreshed.
I found with early versions of XP (i.e before SP2) that this process could be very slow. Worse, the links were refreshed every time the form was opened.
SP2 seemed to fix that.
Hope this helps.
I am using SP2. There are between 6-10 users at a time. I tried putting the front end on the stored locally, but that actually made it even slower, I had assumed because the data had to be pulled from so far away.
Barry, how can I avoid having the links refresh every time I open? I assume that that would make the form open slow the first time (when the link is established) and every time afterwards would open quickly.
Robin
I converted the front end to an MDE file, placed on the C-drive, and performance has been better. However, still opening the forms is slow.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Snyke |
last post by:
Hi.
I have a command line script which works really fine, the only problem
is that it take *really* long for the first output to be printed on
screen.
Since I also get some HTTP headers I'm suspecting that some sort of
output buffering is used.
How can I tell PHP to flush the buffer automatically (without using
flush(); after every print or echo) and to remove the headers?
|
by: James Kimble |
last post by:
I've inherited a program that was developed in Visual Studio and I'm
having a problem with build times. The program is about 250,000 lines
and I'm storing the entire project on a network drive. We've got
gigabyte ethernet and it's a high speed raid array but it still takes
about 5
minutes to do the smallest recompile and about 1 hour and 15 minutes
to do a full rebuild (pretty annoying).
I'd like to move the object and binary files to...
|
by: Apollo |
last post by:
I have about 20K records that result from the following query. Front end for the
database is ACCESS97 and pulling up 20K records makes a huge performance hit.
For the form in question I am using PASSTHROUGH type query (the one that just
passes everything straight to server without ODBC).
NOTE: souce_for_inquiries_form is the TEMP table and is searchable in the from
(it feeds a pull-down list).
SELECT inquiries.inquiry_id,...
|
by: dvumani |
last post by:
I have C code which computes the row sums of a matrix, divide each
element of each row with the row sum and then compute the column sum of
the resulting matrix. Is there a way I can speed up the code in C:
/* Here is the code */
// Table is "wij"
int i, j;
for(i = 0; i < N; ++i)
{
|
by: Jon Skeet |
last post by:
I'm trying to speed up a data migration tool I'm writing that uses COM
interop. Currently I'm accessing each field within a record
individually, which works, but means going across the managed/unmanaged
boundary a heck of a lot.
The COM object I'm working with has a method which I'm sure *should*
help, but I can't get it to work. It's described in the documentation
as:
GetDataEx method:
| | |
by: Robert Wilkens |
last post by:
Ok... This may be the wrong forum, but it's the first place I'm trying.
I'm new to C# and just implemented the 3-tier Distributed application from
Chapter 1 (the first walkthrough) in the "Walkthrough" book that comes with
Visual Studio .NET 2003 Enterprise Architect.
My first observation is -- woah, is this thing slow. From the time I
clicked "load" to the time I had a populated data set on the windows-based
app was almost 5-10...
|
by: Sarah Smith |
last post by:
Hello,
I am a bit of a newbie to VB.NET, but not totally new. I took the
plunge recently and decided (along with my colleagues), to try to
convert/port a VB6 client/server app to .Net.
(I'm not using any upgrade tools, I'm just re-writing).
I have be learning/testing .net with SDI type forms and now I'm
actually working on the conversion, I'm starting to worry that VB.net
|
by: jcrouse |
last post by:
I have a program that is an external viewer. It is launched with a hotkey
from within another application. The program has 30 labels that can be
displayed. Since the labels may not always be oriented the same as the
Operating System I needed to use the Label_Paint event to PAINT the labels
text if it not oriented the same as the operating system. I am trying to
figure out a way to make this event happen faster or optimize it if
possible. I...
|
by: Mark Reed |
last post by:
All,
I have built a database recently which resides on a network server which
is constantly being re-structured. This is something I have no control over
so have had to incorporate a means by which the backend moving will not
cause too much of a headache and anyone can fix.
I decided to use an INI file to store several variables which can and often
do change.
I've also added a logging procedure which writes events to a text file to
aid...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| | |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
