Re: Slow database
From: Jeff Boyce (JeffBoyce_IF_at_msn.com-DISCARD_HYPHEN_TO_END)
Date: 01/04/05
- Next message: anonymous_at_discussions.microsoft.com: "How do I import a distribution list?"
- Previous message: John Nurick: "Re: Access 95 to 2000 and back question"
- In reply to: yooper_ssm: "Slow database"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 4 Jan 2005 03:16:56 -0800
One possibility is an over-zealous anti-viral application. Check Tony's
site for more possibilities:
http://www.granite.ab.ca/accsmstr.htm
-- Good luck Jeff Boyce <Access MVP> "yooper_ssm" <yooperssm@discussions.microsoft.com> wrote in message news:AF36DD30-5B1D-4EE7-9860-5083BD0E1401@microsoft.com... > Equipment: > We are using a gigabit network with static IPs to each workstation > Server is Win2K Server > Workstation is XP Pro and or 2K Pro > > Problem: > The data bases are located on the server. The forms are accessed from > workstations via access or access runtime. We have been dealing with the > databases being really slow. So today I thought I would rebuild a database > and try to weed out some of the data that is not needed to see if I can speed > the thing up. Well after I deleted all forms but one, all queries and > reports. I then deleted all non-essential tables - i.e. indexing tables.... I > have a table that contains the first and last day of every week of 2005 with > the year and week number - total number of datum is 208. I noticed it still > takes 5 seconds for it to open. I then created a new database and pasted the > information from this table into it, and it opens up just like is should - > very fast. I then opened up the database I was originally editing and deleted > all of the "Linked" tables and the performance of the table went from 5 > seconds to instant. The table that I'm opening contains no lookup fields or > anything of that nature. So to kind of start this experiment over I started a > new database and imported the problem table opened it and again it opened > instantly. I imported the other table using the link option, and the > performance of the table degrades back to 5 seconds. I know 5 seconds is not > a lot of time but sometimes in the middle of the day the forms can and have > taken up to 5 minutes to open. > > Question: > Is there a setting in access like snapshot record set or something of this > nature that would speed these tables up? > > Why would this slow down the performance of a table that has absolutely > NOTHING to do with it? > > It's like the database has to read all of the tables in order to display the > information from one! > > Thanks > Mike Sundman >
- Next message: anonymous_at_discussions.microsoft.com: "How do I import a distribution list?"
- Previous message: John Nurick: "Re: Access 95 to 2000 and back question"
- In reply to: yooper_ssm: "Slow database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
