Which is more efficient, faster?

Results 1 to 2 of 2

Thread: Which is more efficient, faster?

  1. #1
    Join Date
    Dec 1969

    Default Which is more efficient, faster?

    I have dozens of pages that access a SQL database. I&#039m wondering which is the better way to avoid duplicating the connection string on every page. A server side include or an application variable?<BR><BR>Does one have a distinct advantage?<BR><BR>thanks.

  2. #2
    Jason Miller Guest

    Default RE: Which is more efficient, faster?

    The fastest way I&#039ve found is to compress all of your database requests per page into an isolated spot (probably near the top of the page). This would generally indicate that SSI is better, since, if you&#039re compressing your access points, you can also explicitly terminate the connection to ensure that you&#039re properly compressed.<BR><BR>Now for the visual example:<BR><BR>Page (blah blah)<BR>-- attach<BR>Content (needs database)<BR>-- detach<BR>/Page<BR><BR>sped up incredibly when I went to<BR><BR>Page (blah blah)<BR>-- attach, .getRows the content, detach<BR>Content (needs array)<BR>/Page

Posting Permissions

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