How to improve the database loading speed RRS feed

  • Question

  •  How to improve the database loading speed in .netcf application.
    In my  .netcf application,  it's so slow when i loading a large database, hower, it's faster when i reduce the database rows from 10000 rows to 100 rows.How  do i?
    Thank your answer!
    select happy from everywhere
    Monday, December 29, 2008 3:43 AM


  • Hi,

    When you say you are loading a large database, can I ask what the reason for this is? If, for example, you are loading the records to display on a datagrid, you might consider loading pages of data rather than the whole database. This will reduce the time to load the data as you can only effectively display a handful of records. You can then handle the loading of next or previous pages as and when the user requests this rather than loading everything "just in case" the user wants to view all the records.

    Hope this helps.

    Paul Diston
    Monday, December 29, 2008 9:17 AM