[dba-SQLServer] Re: [AccessD] Access 2000 - ADP - Open View very slowwwww...

Francisco H Tapia my.lists at verizon.net
Thu Apr 17 18:08:10 CDT 2003


Note: Sprocs run faster than views in SQL Server, that's because the engine
keeps the compiled version in cache and gives better performance.  IIRC, the
views are not indexed, thus you hitting the previous views based of indexed
tables you are taking a performance hits... try posting the query (view) on
the sqlserver list for more analysis :)

-Francisco
http://rcm.netfirms.com

On Thursday, April 17, 2003 12:57 PM [GMT-8],
Tom Adams <tomadatn at bellsouth.net> wrote:

: Against Sql Server 7 with latest service packs running on an NT4
: machine with the latest service packs.
:
: I've got a view that is based on 2 other views and has a Case
: statement in it.
:
: It runs in about 5-10 seconds in Enterprise Manager but is timing
: out/hanging up in Access.
:
: Any ideas???
:
: Thanks - Tom
:
:
: _______________________________________________
: AccessD mailing list
: AccessD at databaseadvisors.com
: http://databaseadvisors.com/mailman/listinfo/accessd
: Website: http://www.databaseadvisors.com




More information about the dba-SQLServer mailing list