Problem while using DataSet RRS feed

  • Question


    Hi All,


    I am developing a windows application using c# 2008.

    on windows form i am using tab control and in each tab section i am showing data like some details and on next section chart etc......

    for showing details i am using DataSet in that DataSet i have 10 tables and each table more then 1 lack rows is there.

    in that my application is getting very slow........

    so is there any way to improve performance ..... like store in binaryformater and then show.


    waiting for your feavorable response.

    thanks in advance




    Thursday, December 4, 2008 3:40 AM

All replies

  • Hello,

    Please,could you post the SELECT statements you are using to fill your datables ?

    One of the "classical" reasons of slowness is to do a SELECT on a table without index or without using a search on a primary key

    Another one is that you are using indexes or primary keys with many records having the same value
    It is the case when you are using Male or Female as index in a table with 10,000 rows

    We are waiting for your feedback to try to help you more efficiently

    Have a nice day
    Please remember to click 'Mark as Answer' on the post that helped you. Unmark if it provides no help
    Saturday, December 13, 2008 11:44 AM