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

[vb guy]

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?

[Stever]

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?

[Ashish Desai]

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?