performance of Access queries

Results 1 to 2 of 2

Thread: performance of Access queries

  1. #1
    Joel M Guest

    Default performance of Access queries

    hello, I&#039m making a small intranet that is gonna use a simple access database... and I was just wodering if instead of using dynamic sql statement... if it would be better to refer to the queries (a la Stored Procedures)<BR><BR>would there be any performance increase?<BR><BR>thanks in advance,<BR>Joel M<BR>

  2. #2
    Richard A. Lowe Guest

    Default RE: performance of Access queries

    Performance: No<BR>Other reasonse: maybe<BR><BR>I usually put something between my actual DB tables and the ASP code using them, either views (queries in Access) or stored procs in SQL Server/Oracle. It can help when the database structure gets changed.<BR><BR>Richard

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts