• (cs) in reply to warispeace

    warispeace:
    Brilliant!  Of course you're right:  returning the ENTIRE table to the middle-tier is much faster than asking the db for a count...

    I think you mean "Brillant!", don't you?

  • moobar (unregistered) in reply to
    Anonymous:
    I'm guessing many of you here have little or no experience developing enterprise software.  An important goal in developing enterprise software is scalability and in order to scale, often times you want to distribute the load away from your SQL server to a middle-tier server.  By counting the records on the middle-tier you are saving valuable processor cycles on the database server.


    WTF?

    You're saying that copying an entire table table (potentially 1million+ record) into a result set and returning it over a network (ie, SELECT * FROM ) is less load than SELECT count(*) which returns a result set with a single row and column?

    Any people wonder why so many enterprise-level applications fail to meet their customer requirements.
  • moobar (unregistered) in reply to
    Anonymous:
    I've seen this several times in the past with straight ASP/VBScript.  When I questioned it, I was told that some of the ODBC drivers in use did not provide a count back to the dataset so this was the work around. 
    shudder...


    I think you were being given a 'fudge' excuse.  The count isn't returned to the driver, it's stored within a result set within the DB and the result set is returned to the driver. 
  • Cool Guy (unregistered) in reply to

    You guys are all dweebs

  • You can't be serious (unregistered) in reply to Cool Guy

    You guys are all dweebs.

    No some of this people posting here are very insecure and therefore angry.

    The site is quite funny and informative though.

    BTW we've all been guilty of several WTFs at some point in our lives.

    If you feel yourself getting that vituperative. Go for a walk, think about your dog, or something. Computers and even more so the "businesses" that depend on them are not worthy of so much rage.

  • You can't be serious (unregistered) in reply to You can't be serious

    So many spelling and gramatical errors in such a short piece of writing.

    I need my bed.

    Goodnight. X X X

Leave a comment on “Count Rowula”

Log In or post as a guest

Replying to comment #:

Log Out

« Return to Article