Good day,
I have inhereted an Access DB that is used to ask people questions about network maintance. I have been tasked with ripping this thing apart and creating a new version. I have most of everything figured out, but need some advice on the actually query of the questions.
*DB Operation* When the user first uses the db, they create a user profile; login name, password, phone, etc..... They also define which types of networks they administer (over 60 flavors). Once they have completed the profiler, I have a query setup to pull all the questions related to thier types of installed networks. I have several different ways of doing this, but am not quite sure on how to keep the database managable; for performance, size, and programming. As of right now, I have a semi-working If/then statements, but the performance is lacking and I have added about 50 additional network types.
Any Ideas would be greatly appreciated!
Thanks!!
Kendall
4 1354 @phillikl
Hey Kendall,
First of all, Welcome to Bytes.com
To answer your general question, there are many tweeks that can be done to improve performance. The main one is make sure that all your primary keys are indexe, and searched items are also indexed as well. Making sure that any table lookups and or links are also indexed. Make sure about having cleaning written code.
If you're need more detail about your specific project, it would help if you posted any table structures, queries, VBA code and so on. Then you can feel free to ask any questions that you have about your project.
I hope that helps,
Joe P.
NeoPa 32,557
Recognized Expert Moderator MVP
If you have 60 or so If/ElseIf statement then you could certainly look at tidying that up.
I would recommend the Select ... Case construct instead, except that if you have this information in a table (you certainly should.) then you should be looking at something SQL based to process through the data.
We would need more details to progress with this, but I'm sure there is scope for improvement.
Thanks for the help, do to company policy and information I am working with; I am going to have to put this differently from the orginal. Once I get my architecture rebuilt, I will back for questions For Sure!!
Thanks again,
Kendall
NeoPa 32,557
Recognized Expert Moderator MVP
We'll look forward to that.
Welcome to Bytes!
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Cristian Hasbun from Chile |
last post by:
I need a win32com guru please...
i'm not python expert, but i understand mi trouble...
Requirements:
Hook EyesWeb 3.2.0 (http://www.eyesweb.org) COM Module with Python
2.0.1
i used win32com...
|
by: Tim Gaunt |
last post by:
Hi,
I'm hoping that someone will be able to help me with this one, I'm
developing an application which basically inserts a load of data into the
database ready for validation at a later date, I...
|
by: Laiverd.COM |
last post by:
Hi, In the following function I keep getting a 'Object expected at line 75
char 5' but for the life of me I cannot find the error. Maybe someone would
be so kin to have a look? I indicated the...
|
by: TonyM |
last post by:
Hi all,
I have an application with a few different Windows forms. I am trying to
update a statusbar panel's text that is in the main form, from another form.
When I set the statusbar and the...
|
by: GeekBoy |
last post by:
I understand the benefit of pushing the StateServer process onto
another computer to "balance" the load and take some cpu and memory
usage off the web server, but how much could it possibly help?...
| |
by: Rosanne |
last post by:
Has anyone ever used Windows Eyes screen reading software? I just
installed it on my machine. Just wondering if any of you have any
experience with it and could possibly offer a good web site for...
|
by: Barret Bonden |
last post by:
As an old programmer just now looking at VB.net I have a question:
How does one simply open one form from another ? I don't mean how does one
create a new instance of that form , but rather how...
|
by: Bailey.Hudson |
last post by:
C# is supposed to be an improvement over C++, and I've read a zillion
debates on using "using", no "typedef", no "include" to no avail. So
how can I implement data dictionary-like functionality in...
|
by: gordon |
last post by:
I aksed a few days ago about static methods and got some good answers that
were really useful.
Now I am not sure if about the use of static on members (variables) and
classes.
Can someone...
|
by: Neo Geshel |
last post by:
I am seeking a method to load one JS file directly into another,
*without* having to dynamically write <scripttags.
Is there any method whereby I can call only one external JS file using a ...
|
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,...
| |
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,...
|
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...
|
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...
|
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...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new...
| |
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...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |