Fast,single operation to load 1000 recs raw data into Ctl? No DbSvr

[rogerv]

DESC: This internal corp app will allow a user to consolidate and aggregate proprietary statistical memory cache pages from multiple remote systems servers.

PRB: Ideally, we need to be able to load a 1000 recs (80 bytes/Rec, 10 fields) into a user-friendly control very quickly and refresh the updated view every few secs.

NEED: On a p3/600/128 machine we are looking for a benchmark of <= .25 secs to load this chunk.

HIST: Rich/Textbox is not user-friendly enough. ADO works nicely with a db svr backend, but we don't want to go there. Text driver DSN so far doesn't bench out better than .70 secs.

HELP: Does anybody know of a LIST or DATA CONTROL that can be loaded quickly, in one op, from one datasource, either from memory (preferably) or from a text file?

 

[MichaelRed]

You can usually use an ADO connection to a variety of sources. You do not state the format of the data (text? MS SLQ Server? Oracle? Proprietary 'junque'?), so no 'concrete' answer can be provided.

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[strongm]

Well, rogerv does state that they don't want to go the route of a database server backend...

 

[MichaelRed]

Yeah. &quot;I only want the sun, the moon, the stars, most of the space in between ... and oh-by-the-way the rights to whatever I haven't enumerated.

It needs to be better (faster) than whatever else is available. It needs to run (fast) on three or four year old processors using some unknown network (LanTastic anyone?). It needs to load 80kb of data from an unknown source (dbIII?, Paradox ver ??.?, ... Free Text?) Appears to be running on multiple processors (hmmm, 22 of these pIII 600MHz all attempting to get access to the 80kb dbIII files every few (between 3 and 8) seconds.

And - oh-by-the way - please do it for free ...

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[scorpio66]

This will do it:

Const Record0001 = &quot;...(80 bytes)&quot;
Const Record0002 = &quot;...(80 bytes)&quot;
...
Const Record1000 = &quot;...(80 bytes)&quot;

Compile it, all your records should be loaded in significantly less that 0.25 sec, straight from memory

Chaz