Post reply

sort order

  • July 20, 2007 at 9:37 am

    #721188

    I would sort the data locally at the app. That way the user could change his mind after the initial fetch of the data and could have it re-sorted WITHOUT another trip across the (intra)net to re-fetch the data and another database search. Have the sproc return the results sorted in the most common way.


    PeteK
    I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.

  • July 20, 2007 at 5:00 pm

    #721301

    I guess it's also about returning "20 first rows" or "Rows 21-40" in order specified.

    To do sorting in application you need to pump while dataset from DB, even if user does not need it.

    It will work OK until it's in development stage and you've got up to 100 test records. But as soon as it's gone to production response time will increase day after day until somebody will rewrite application and apply sorting and pagination in stored procedure.

    _____________
    Code for TallyGenerator

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply