Post reply

Application Performance with more number of records.

  • September 9, 2004 at 7:00 am

    #109436

    Hi,

    I have got few tables which hv more than 4-5 million records.

    Will it affect the performance of the system.

    Backend - SQL Server 2000 (has got huge amt of memory in server)

    Front-end - ASP.Net Web application.

    Will there be any performance issue When you insert a record into

    the table which has got more than 4-5 million of records.

    Thanks,

  • September 10, 2004 at 2:56 am

    #522476

    size does matter...but as long as you manage the items that can hit performance (indices (or lack of), poor queries, lengthy transactions, HW issues...disk perf, disk capacity... locking)...you should be o.k....SS can and does handle databases of >100Gb.

     

    any issues...post the code + ddl here for a 2nd opinion/rewrite suggestion.

    ps....stay away from cursors.

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

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