Post reply

Administration

  • October 2, 2005 at 11:59 pm

    #165508

    One of my table with 50 columns contains 3,43,416 records. While i give "select * from table_name" it takes me around 30 seconds to display the result set. The table is indexed on the primary key.

    Is there any way to display more faster.

  • October 3, 2005 at 12:28 am

    #594497

    With that select statement, you're telling the server to give you everything and it's returning in 30 seconds. I don't know about anyone else, but if my 50 column table returned 3mil+ rows in 30 seconds I'd be happy.

    There is a way to display the information faster. Get bigger faster hardware or you could just select the columns and data that you're interested in.

     

     

    --------------------
    Colt 45 - the original point and click interface

  • October 3, 2005 at 8:14 am

    #594582

    Thanks Phill

Viewing 3 posts - 1 through 2 (of 2 total)

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