Speed up loading .csv file on treeview

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Kenzo
    New Member
    • Mar 2007
    • 1

    #1

    Speed up loading .csv file on treeview

    Hi All,

    This situation is a Treeview where you locate the folder consist of .csv files.

    As the file size of .csv increased, the loading speed of .csv file tend to get slower and slower. It occupied more than 15minutes to load the .csv file in the viewer.

    Is there any way to make it faster?

    Thanks.
  • Killer42
    Recognized Expert Expert
    • Oct 2006
    • 8429

    #2
    Originally posted by Kenzo
    Hi All,

    This situation is a Treeview where you locate the folder consist of .csv files.

    As the file size of .csv increased, the loading speed of .csv file tend to get slower and slower. It occupied more than 15minutes to load the .csv file in the viewer.

    Is there any way to make it faster?
    Can you please explain a little more? Are you saying that the contens of a CSV file are being loaded into the TreeView? Or is the TreeView showing a directory structure which is used to locate the file? :confused:

    Also, what version of VB are you using?

    Comment

    • vijaydiwakar
      Contributor
      • Feb 2007
      • 579

      #3
      Originally posted by Kenzo
      Hi All,

      This situation is a Treeview where you locate the folder consist of .csv files.

      As the file size of .csv increased, the loading speed of .csv file tend to get slower and slower. It occupied more than 15minutes to load the .csv file in the viewer.

      Is there any way to make it faster?

      Thanks.
      pls explain in detail
      try to use doevents

      Comment

      • Killer42
        Recognized Expert Expert
        • Oct 2006
        • 8429

        #4
        Originally posted by vijaydiwakar
        pls explain in detail
        try to use doevents
        I'd just like to point out that DoEvent may be useful in many situations, but it will rarely if ever make things faster. More likely slower, in fact.

        Comment

        • vijaydiwakar
          Contributor
          • Feb 2007
          • 579

          #5
          Originally posted by Killer42
          I'd just like to point out that DoEvent may be useful in many situations, but it will rarely if ever make things faster. More likely slower, in fact.
          The main theame is to provide Processor some time to complete it processing

          Comment

          • pongscript
            New Member
            • Mar 2007
            • 27

            #6
            did you say you load the content of the csv to treeview.. if this is the situation.. ofcourse it would take more time to load a 2 mb of csv than 5 kb of csv content..

            but if you are refering to a directory structure...the n loading of file structure into the treeview depends on the number of files located on the specified directory.

            Comment

            Working...