473,396 Members | 1,743 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,396 software developers and data experts.

Boost My Speed!

Presto731
I have a database set up that 5-10 people on my network may be using at any given time. The majority of the tables they feed from are in a master database seperate from the one they use. I do this mainly so a table doesn't get accidentally deleted or ruined even though I back both databases up often.

Is there any way to to speed up the reports, forms and queries they run? I run the compact and repair often as well.

i know a lot will depend on the computer itself but they are all brand new dells with all the bells and whistles.

anyone have any tips or tricks to make the databases on the local machines run faster?.
Aug 2 '07 #1
3 1566
Rabbit
12,516 Expert Mod 8TB
It's not so much the local machine as the congestion on the network from having that many people connected to that master database. There's not much you can do about it that I know of.
Aug 2 '07 #2
I figured as much. But i will still take suggestions

Can i out tables that are only used to look up information on each local machine, would that help?
Aug 2 '07 #3
Rabbit
12,516 Expert Mod 8TB
I figured as much. But i will still take suggestions

Can i out tables that are only used to look up information on each local machine, would that help?
It would, the less it depends on the network the better. But the more you put on the local machine, the harder updates become. For the purposes of speed, any tables that aren't updated by the users themselves can be put on the local machine.
Aug 2 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Andreas Zita | last post by:
Hi I'm trying to figure out why my .net app take ages to start for the first time. Well over 10 seconds. I'm not doing anything particullary cpu intense at startup so I'm a bit confused. I have...
5
by: jimfortune | last post by:
I receive occasional notices from the Intel Software Network. I got one concerning the Intel Math Kernal Library 8.0. The blurb is at: ...
17
by: Howard Gardner | last post by:
/* If I am using boost, then how should I write this program? As it sits, this program is using SFINAE to determine whether or not a type supports particular syntax. I suspect that there is...
335
by: extrudedaluminiu | last post by:
Hi, Is there any group in the manner of the C++ Boost group that works on the evolution of the C language? Or is there any group that performs an equivalent function? Thanks, -vs
14
by: IndyStef | last post by:
Hi all, This is an inquiry into the usability of the boost libraries. We are a C++ shop, and have been using STL for some time now. When the question about using boost came up, some developers...
85
by: g | last post by:
Hello, is there any library for C as Boost is for C++? thanks in advance,
8
by: Matt England | last post by:
My team currently using Boost Threads, but we are considering switching to ZThreads. (We seek cross-platform, C++ multithreading capabilities in an external library.) ZThread(s): ...
1
by: Noah Roberts | last post by:
Trying to use boost::function in a C++/CLI program. Here is code: pragma once #include <boost/function.hpp> #include <boost/shared_ptr.hpp> #include <vector> using namespace System;
5
by: miroslaw.makowiecki | last post by:
How do we think about optymalization boost.variant on account of a memory and a speed of action in its boost library in C++ language. Advice in thanks.
6
by: Juha Nieminen | last post by:
I tested the speed of a simple program like this: //------------------------------------------------------------ #include <list> #include <boost/pool/pool_alloc.hpp> int main() { typedef...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
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,...
0
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...
0
tracyyun
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...
0
agi2029
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 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.