Row count problem


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: Row count problem

Hybrid View

  1. #1
    Hari Guest

    Row count problem


    Changing the data type from Integer to Long could be one solution (if the
    table is too large).
    The idea of looping through the recordset to increment a counter (as suggested
    by someone in this forum), SHOULD BE AVOIDED - it is a very ineffecient
    way of doing it.


  2. #2
    Michael Culley Guest

    Re: Row count problem

    Um, to whom where you replying?

    --
    Michael Culley
    www.vbdotcom.com


    "Hari" <rhariharan@hotmail.com> wrote in message
    news:3d3e446f$1@10.1.10.29...
    >
    > Changing the data type from Integer to Long could be one solution (if the
    > table is too large).
    > The idea of looping through the recordset to increment a counter (as

    suggested
    > by someone in this forum), SHOULD BE AVOIDED - it is a very ineffecient
    > way of doing it.
    >




  3. #3
    JB Guest

    Re: Row count problem


    "Hari" <rhariharan@hotmail.com> wrote:
    >
    >Changing the data type from Integer to Long could be one solution (if the
    >table is too large).
    >The idea of looping through the recordset to increment a counter (as suggested
    >by someone in this forum), SHOULD BE AVOIDED - it is a very ineffecient
    >way of doing it.
    >

    '****************************************
    Your saying it should be avoided...??? Depending on the size of the database
    it doesn't seem like a bad idea. Just messing around I didn't see a noticable
    difference in time when doing it a couple different ways? When saying "SHOULD
    BE AVOIDED" you should tell the us why you think that! If interested in
    knowing what you and others think the best/better way is.

    Thanks...

    jb

  4. #4
    Michael Culley Guest

    Re: Row count problem

    I agree that it doesn't have to be avoided in all situations, but in most it
    is very easy to avoid. I would say the best method would be to execute a
    "Select Count(*) FROM MyTable"

    --
    Michael Culley
    www.vbdotcom.com


    "JB" <vb.@127.0.0.1> wrote in message news:3d3e9520$1@10.1.10.29...
    >
    > "Hari" <rhariharan@hotmail.com> wrote:
    > >
    > >Changing the data type from Integer to Long could be one solution (if the
    > >table is too large).
    > >The idea of looping through the recordset to increment a counter (as

    suggested
    > >by someone in this forum), SHOULD BE AVOIDED - it is a very ineffecient
    > >way of doing it.
    > >

    > '****************************************
    > Your saying it should be avoided...??? Depending on the size of the

    database
    > it doesn't seem like a bad idea. Just messing around I didn't see a

    noticable
    > difference in time when doing it a couple different ways? When saying

    "SHOULD
    > BE AVOIDED" you should tell the us why you think that! If interested in
    > knowing what you and others think the best/better way is.
    >
    > Thanks...
    >
    > jb




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