Go Back   Access World Forums > Microsoft Access Discussion > General

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 10-05-2011, 05:26 PM   #1
Raymas
Newly Registered User
 
Join Date: Mar 2011
Posts: 21
Thanks: 8
Thanked 0 Times in 0 Posts
Raymas is on a distinguished road
Database efficiency with generating tables.

Hi all,

I have been working on product database since the start of the year. I had never used MS Access before, and I have leant a great deal. But this is where I begin to doubt my abilities, as I have taught myself mostly everything I know.

I am just wondering will I the end user see noticable lag in the database when it is at capacity, if I regenerate many tables on some functions? I am seeing this being an issue when cascading updates occur. For instance, at the far end of the scale; if I update the currency exchange rates, this will regenerate the cost of raw materials in the products, which will update the all the product total costs, which will update all the prices for all the products. There is a mix of completely regenerating tables and just updating specific parts of tables. But if in the worst case scenario, all tables were regenerated due to a small change, would the end user experience any noticeable lag?

There are upto 5000 records in some of the tables, and upto 5/6 fields in each. At what sort of capacity or workload does access appear to lag? I'm just thinking back to high school, when some programmes would take forever to update or perform a certain task (or even photoshop on low end systems these days, haha), and really want to avoid this for the end user.

Raymas is offline   Reply With Quote
 

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Query Across Two Tables Generating Odd Balls daygo140 Queries 7 06-09-2008 06:22 AM
Generating Powerpoint Slideshow w/Tables airforceruss Modules & VBA 6 11-21-2007 11:24 AM
Generating a query using 4 tables and totalling one of the columns :S HairyArse Queries 1 02-03-2006 06:47 AM
Generating Totally New Tables via Data Input tbaxter General 2 01-15-2003 12:15 PM
Generating reports from multiple tables Loriebob Reports 1 08-17-2001 04:18 PM




All times are GMT -8. The time now is 09:12 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World