none
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

    vishnu.

     

     

    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