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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com