Prior to today I had a fairly large database, split into front end and back end, the back end residing on a 2-bay Dlink NAS we use as a file server, running in RAID, connected through an old 16 port hub running at 100mbits. Roughly 5-10 users have the front end on their PC and are in the database at the same time.
The problem was the database was very slow moving through records, opening forms, everything was just very sluggish.
I ordered some upgrades that are now in place as of today, a new 24 port cisco switch, the whole network is running gigabit now, a new acer server, one of the mini ones, came with 1TB and runs Window Home Server, as well as a 64GB SSD that the main database is now on (hoping to increase speed there again).
Even after these upgrades are in place, it is only a bit faster. When the backend is on someones computer in a shared folder, or if you have the front and backend on the same computer it is a lot faster. What is the difference between that and how I have it set up on the server? Shouldnt the server be faster? Why is it still sluggish?
8 1920 sicarie 4,677
Recognized Expert Moderator Specialist
I'd recommend baselining everything - look at the CPU usage on the server (both requesting, and the back-end db), NIC speeds, RAM (and RAM utilization), etc...then also do so on the network equipment.
Then compare that baseline with the "best case" of what the equipment is supposed to be able to do. Whatever's peaked is probably your bottleneck.
If none of that works, it might be a db design issue, but I'd start with profiling your network and systems.
- CPU usage is always < 10%, except when fileindexer.exe is doing stuff
- Not sure how to check NIC speeds, but the whole network is running gigabit, all the cards, cables, cisco switch.
Not sure if it could be a design issue, it runs fine on a local machine (not sluggish) as well as if you share the folder on another network computer and access the front end from another.
sicarie 4,677
Recognized Expert Moderator Specialist
What happens when just one user accesses it? Is it still slow?
Yes seems like its always the same speed if 1 user is on or 10
It is a fairly large database, ~90 pages of VBA code, ~50 tables, ~80 forms. I originally thought it was slow just because of the amount of information its loading, but it runs very smoothly when the front end and backend are on the local machine.
Just to clarify, when its running sluggish is when the front end is on the local and the backend shared on the server.
sicarie 4,677
Recognized Expert Moderator Specialist
And is this an MSSQL db?
I'm going to ask for assistance here - I done single-user access database programs, but haven't gotten too far into the coding - it sounds like there may be something between the system and the code that's running inefficiently if it's only the client.
And just to clarify - these queries run significantly faster when executed on the local machine?
No sorry its an Access running Jet Engine for BE.
Its running faster when it IS on the local machine, forms take almost no time to load, same with any tasks being done. When its running slow is when its shared on the server.
Update: Just tried running the backend off another client machine, so i'm running the FE on my machine, the BE is on another, and it is a lot faster than running it off the server. Not quite as fast as with both them on the local, but significantly faster than running off the server or the old NAS.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Steve Juranich |
last post by:
I know that this topic has the potential for blowing up in my face,
but I can't help asking. I've been using Python since 1.5.1, so I'm
not what you'd call a "n00b". I dutifully evangelize on the goodness
of Python whenever I talk with fellow developers, but I always hit a
snag when it comes to discussing the finer points of the execution
model (specifically, exceptions).
Without fail, when I start talking with some of the "old-timers"...
|
by: Jeff Boes |
last post by:
I'm sure this is a concept that's been explored here. I have a table
(fairly simple, just two columns, one of which is a 32-digit checksum)
with several million rows (currently, about 7 million). About a million
times a day we do
select * from my_table where md5 = ?
to verify presence or absence of the row, and base further processing on
that information.
|
by: Chris Stokes |
last post by:
Hi all,
WE currently use PG for the local database on our POS workstations in shops. Data is then extracted and sent back to head office. Also product updates etc are regularly sent to the shops. I have noticed over time that the shop PG databases get slower and slower. If I do a pg_dump, recreate the database and then restore the data - all speed problems are gone and the database folder shrinks in size substantially.
From this...
|
by: James |
last post by:
Hi - I am looking to start a custom database for a small company. I have
normally used Access data storage but have been looking into Xml as a
possible data storage - what are the draw backs of using xml. I believe
speed is an issue but at what size does does an xml database become
unviable - even if you think it is viable in the first place.
--
James Jenkins
www.tamarsolutions.co.uk
...........................................
|
by: PD |
last post by:
I am currently making a dating website.
I want to have some information on how to structure the database and
the php files so that I can achieve speed and efficiency.
Can some one please give me suggestions and point me to references
where I can get this information.
| |
by: c676228 |
last post by:
Hi everyone,
I never used global.asa. I am thinking of load some data in
application_onstart which is read only from database(I mean the data will
never be changed in any asp pages of the applcation) and so any session for
this application doesn't need to reload data from database again, reduce
database connection and procedure call.
Am I right? just doesn't see that kind of comments on-line.
I want to make sure this is the right concept...
|
by: ykhamitkar |
last post by:
Hi There,
I have some questions about ms access database
1. How much data ms access can handle with good speed.
2. Does the size of column affect the speed of ms access database.
(If i keep size as 100 instead of 50 in the Field Size property in design view)
3. If I create a client server application and 10 people work on the same database at the same time, Would it affect the speed of the database
4. Is there any way I can keep a...
|
by: zgh1970 |
last post by:
Hi, Friends,
I need to know how to stop all database process even after db2stop.
How can I stop all database processes?
I have finished upgraded our system test and UAT region from 32-bit to
64-bit.
I followed the following for my system test region:
1. log on aix with root
2. stop the instance
3. db2iupdt -w 64 instance
|
by: railwayplatform |
last post by:
i have database in ms access. whem my data was upto 50 Mb is was good. but right now i have 80 Mb data. and my system data saving and printing speed is too slow i have to wait 2-3 mins to print/save any data.
|
by: nestle |
last post by:
I have DSL with a download speed of 32MB/s and an upload speed of 8MB/s(according to my ISP), and I am using a router. My upload speed is always between 8MB/s and 9MB/s(which is above the max upload speed), ALWAYS. However, my download speed doesn't go over 25MB/s. And when my brother turns on the internet from his computer and takes up half the download/upload speeds (routers automatically split the speeds in two when two computers are using...
|
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: 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: 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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |