Re: can the loading of a large number of records go as quick as in DOS
- From: catharinus <csvanderwerf@xxxxxxxxx>
- Date: Fri, 15 May 2009 05:59:52 -0700 (PDT)
On 15 mei, 14:36, "Dave O." <nob...@xxxxxxxxxxx> wrote:
If you are using OBDC/DAO/whatever to read from a MDB then it should be OK.
From your posting it seems that the old program only loaded data as it was
needed, why can't you use a similar philosophy here?
Secondly is there an apparent delay because the program does not display
until the data is loaded? if so move the data load out of the Form_Load, let
the program show itself then add then records.
There are at least as many different ways to do this as there are
programmers, but as you have given us virtually zero information as to how
you are doing this now, it's not easy to offer firm suggestions as to how to
improve matters.
Regards
Dave O.
"catharinus" <csvanderw...@xxxxxxxxx> wrote in message
news:3f8a6703-6f51-450d-96ac-397caa442bd4@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hello
I have build a windows-copy of a DOS-accounting program.
All works nice, but the only thing that bothers me is the fact
that loading a large number of records is not as quick as in DOS.
How can I solve that problem. The data are shown in a MSHFlexGrid and
comes from an Access-database.
The diference between the DOS-and Windows program is probarbly caused
by using a different technic. It looks as DOS reads all the time from
and to the hard disk (and thus has only the visible records /data in
the memory) as Windows first loads all the records and so has all
these records all the time in memory.
Am I right and is there a solution for the delaying loading in the
windows-
program?
Thanks
Catharinus van der Werf
csvanderw...@xxxxxxxxxx Tekst uit oorspronkelijk bericht niet weergeven -
- Tekst uit oorspronkelijk bericht weergeven -
Oke Dave.
you' re right. I didn;t explain enough. I load the data via Form_load
and use ADO
I open a ADO-connection in which I try to select only the records
needed, but that is
and stays a problem when having 3000 records, because during the
loading I can't exercise
any action
I do this for example as follows:
dim conConnection as adodb.connection
dim mrstRecordSet as adodb.recordset
set ConConnection=new ADODB.Connection
conConnection.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0;
Data Source =\\Database.mdb"
conConnection.Open conConnection.ConnectionString
set mrstRecordSet=Conconnection.execute("Select * from TABELA order by
Number")
do while not mrstRecordSet.EOF
me.text1(0).text=mrstRecordSet.fields(0).value
mrstRecordSet.movenext
loop
This takes tooo long when I need to load 3000 records. Is there a
faster way??
Thanks
Catharinus van der Werf
csvanderwef@xxxxxxxxx
.
- Follow-Ups:
- References:
- Prev by Date: Re: can the loading of a large number of records go as quick as in DOS
- Next by Date: Re: can the loading of a large number of records go as quick as in DOS
- Previous by thread: Re: can the loading of a large number of records go as quick as in DOS
- Next by thread: Re: can the loading of a large number of records go as quick as in DOS
- Index(es):
Relevant Pages
|
