DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: General DB Connection question

  1. #1
    Join Date
    Jan 2007
    Posts
    41

    General DB Connection question

    I am creating a sports website and it will be making DB connections to receive statistics and player information. There are a few pages that need to query 3 different tables in my DB in order to display the desired content.

    I am using loose-typed datasets that are being filled by a class in my app_data folder. Each table query I do is a separate connection to the DB....
    so my question is.... Will there be a problem if these pages that are querying 3 tables will be viewed around 1000 times per month?

    This is the code I have in the class:
    Code:
        Public Function selectCommandProvideString(ByVal queryString As String) As Data.DataTable
            'Fill a datatable with the information asked by the -Select- commandstring
            Dim Constring As String = ConfigurationManager.ConnectionStrings("BirdieClickConnectionString1").ConnectionString
            Dim DatAdapt As New Data.SqlClient.SqlDataAdapter(queryString, Constring)
            Dim dataTbl As New Data.DataTable
            DatAdapt.Fill(dataTbl)
    
            'return th datatable
            Return dataTbl
        End Function
    Last edited by spiffyaldo2; 07-14-2007 at 06:48 PM.

  2. #2
    Join Date
    May 2006
    Posts
    64

  3. #3
    Join Date
    Jan 2007
    Posts
    41
    what is the difference performance wise to open one connection and fill 3 dataTables?

Similar Threads

  1. A General Question
    By neo22 in forum Java
    Replies: 2
    Last Post: 03-28-2006, 04:23 PM
  2. Database Connection Question
    By Tony in forum .NET
    Replies: 2
    Last Post: 03-28-2003, 10:31 AM
  3. General C# question
    By BruceG in forum .NET
    Replies: 3
    Last Post: 03-07-2002, 08:29 PM
  4. DB connection Question
    By PhilipL in forum VB Classic
    Replies: 1
    Last Post: 01-04-2002, 05:56 PM
  5. MSDE/NT Connection problem across domains
    By Will Rickards in forum Database
    Replies: 1
    Last Post: 04-06-2001, 03:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center