How to as quickly sort and display data record as possible in VB?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: How to as quickly sort and display data record as possible in VB?

  1. #1
    vb guy Guest

    How to as quickly sort and display data record as possible in VB?


    I am working on one project to display data records which come from VC++ via
    OLE every 250 millisecond for 2000 records. Once data record gets to VB data,
    it is first is checked in data storage which I use ACCESS to see whether
    it is new, if so data it is added to storage or not modified in storage then
    display it in VB MsFlexGrid. When I run the application, the CPU gets 100%
    and forms are frozen. Which is a better solution to sort the data record
    and display it as quickly as possible?

  2. #2
    Stever Guest

    Re: How to as quickly sort and display data record as possible in VB?

    It sounds like you are using a data binding technique to display the data in
    VB?

    If that is true then you may be having the performance bottlenecks as you
    have mentioned.

    You'll need to partition the VB application from the data source somewhat.
    You need to use the VB MsFlexGrid but don't bind it directly to the Access
    Data base. Create a separate function to grab a snapshot of the data you
    want and then slam it into the grid. Only create a connection to the
    database when you need to get data or do something. Don't hold an open
    connection to a database, especially an Access database.

    Best wishes,

    Steve Goettler

    "vb guy" <zhao790@hotmail.com> wrote in message
    news:39a3ee4c$1@news.devx.com...
    >
    > I am working on one project to display data records which come from VC++

    via
    > OLE every 250 millisecond for 2000 records. Once data record gets to VB

    data,
    > it is first is checked in data storage which I use ACCESS to see whether
    > it is new, if so data it is added to storage or not modified in storage

    then
    > display it in VB MsFlexGrid. When I run the application, the CPU gets 100%
    > and forms are frozen. Which is a better solution to sort the data record
    > and display it as quickly as possible?




  3. #3
    Ashish Desai Guest

    Re: How to as quickly sort and display data record as possible in VB?

    Its not clear if you are binding the grid to the database or just a
    recordset.

    You might want to just create a recordset,
    bind the grid to the recordset and
    append the data to the recordset as it comes in.
    This way you don't hold up to the database connection.

    The recordset object can be used in a standalone manner with no dependencies
    on
    a database.

    Ashish

    "vb guy" <zhao790@hotmail.com> wrote in message
    news:39a3ee4c$1@news.devx.com...
    >
    > I am working on one project to display data records which come from VC++

    via
    > OLE every 250 millisecond for 2000 records. Once data record gets to VB

    data,
    > it is first is checked in data storage which I use ACCESS to see whether
    > it is new, if so data it is added to storage or not modified in storage

    then
    > display it in VB MsFlexGrid. When I run the application, the CPU gets 100%
    > and forms are frozen. Which is a better solution to sort the data record
    > and display it as quickly as possible?




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center