Re: repetitive query to sysobjects in an ADP
- From: "aaron.kempf@xxxxxxxxx" <aaron.kempf@xxxxxxxxx>
- Date: 28 Dec 2006 17:15:25 -0800
fluow
that was really really really helpful information.
thank you SO much
-Aaron
flouw wrote:
SQL 2000 was slow because of sp_tables. We implemented a modified sp_tables
in our application database that does not resolve Active Directory since we
control application access through the menu structure of the ADP and users
have no access to the db window. The first time so anything on the
connection to SQL 2000, you will notice a call to sp_tables that can be
really slow. I cannot comment on SQL 2005.
"Dee_J" wrote:
When I open an SQL 2005 table from within the ADP, it takes 3-4 minutes to
open it. This happens only once, and only for the first table that will be
opened.
Looking in the profiler I see 100's of statements like this:
select object_name(sotblfk.id), user_name(sotblfk.uid),
object_name(sotblrk.id), user_name(sotblrk.uid) from sysreferences srfk,
sysobjects sofk, sysobjects sotblfk, sysobjects
sotblrk where srfk.constid = sofk.id and srfk.fkeyid = sotblfk.id and
srfk.rkeyid = sotblrk.id and user_name(sofk.uid) = N'dbo' and
object_name(sofk.id) = N'FK_Purchase Order
Analysis_Purchase Order'
Apparently access is querying the system table for every single relationship
in the database.
Does anybody have a solution for this?
By the way the same thing happens to the same db but on SQL 2000. However
for some reason the querying is much faster in SQL2000 and the first table
opens up after about 1 minute.
Thanks
Dimitris
.
- Prev by Date: Re: closing DB connections
- Next by Date: Re: Shrinking MDF and LDF Files
- Previous by thread: Re: repetitive query to sysobjects in an ADP
- Index(es):
Relevant Pages
|
