Hello Colin,
> We have a 5GB Database FB2.5 Win2008 Server 4 Core M/C, 143 tables, > problem with table INV 48K Records > > When everyone logs off and then log on, access to INV is slow for the > last 7K Records. If we fetch all, it takes forever, but eventually can > log off and log on again and all is ok. Same is OK if we set all > indexes ACTIVE (takes 4 hours for this table), or do a backup. Also if > we sweep. this takes the same or more time. > It sounds more like performance problem. Though you can always ask for free corruption investigation to make sure there is no problem. > > Questions: > > If we backup and restore the database is like new? data exported and > then reloaded into a copied schema? This seems to work. > Almost - internal compiled representation of stored procedures and triggers is not recompiled with backup/restore. > > Can sweep occur if the database has connections, but no activity? If > it did, then we would not get all the sweep operations stacked up. > In general - yes, it depends on transaction's markers activity. > > > Why does sweep (or the slow backup) take so long and if so, why is > there no cpu load? I would have thought that the CPU would have been busy. > Probably application produces a lot of version. > > > In the app - one transaction and all datasets/queries/procedures are > commitretaining. > > And, and why always this table - treated much the same as other tables. > > Are there special settings for the database connection? and how can we > know that this might happen (so we could backup and restore before the > last user logged out)? > I would say there is no problem with corruption and not enough information to answer performance-related questions. Regards, Alexey Kovyazin IBSurgeon (www.ib-aid.com) > > Lawrence > > [Non-text portions of this message have been removed]