Wrox Programmer Forums
|
ASP Forms As of Oct 5, 2005, this forum is now locked. Please use "Classic ASP beginner" at http://p2p.wrox.com/forum.asp?FORUM_ID=54 or "Classic ASP Professional" http://p2p.wrox.com/forum.asp?FORUM_ID=56 instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP Forms section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 16th, 2005, 08:10 AM
Friend of Wrox
 
Join Date: May 2005
Posts: 149
Thanks: 0
Thanked 0 Times in 0 Posts
Default retrieve date from more than 1 table

Hi,
I have a question.
Does it make any problem in performance issues when I retrieve data from 6 or 7 tables in database in one single page and create 6 or 7 recordset?
thanks

 
Old May 17th, 2005, 01:31 AM
Friend of Wrox
 
Join Date: Apr 2005
Posts: 186
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi,

In such cases it is better to use single or minimum number of database hits. If you are using SQL server/oracle you get the whole thing in a single hit using an SP

Prashant






Similar Threads
Thread Thread Starter Forum Replies Last Post
retrieve date with format (M Y) form database php Mahmoud82 PHP How-To 2 November 30th, 2006 07:10 AM
How to retrieve sistem date?? MAKO C# 1 April 12th, 2006 12:59 PM
Retrieve Date/Time From Network Server wscheiman Access VBA 3 February 21st, 2006 08:56 AM
how to retrieve the current date from the calendar johnsonlim026 ASP.NET 1.0 and 1.1 Basics 1 July 8th, 2005 01:19 PM
retrieve from Access by Date Toran Classic ASP Databases 2 May 4th, 2005 12:53 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.