Re: [Ql-Users] Why so slow?

[Klaus-Peter Greiner]

Nearby, i am eagerly watching this list since years; so i am the third 
listener 8-)


regards
Klaus-Peter Greiner

Am 12.10.16 um 11:45 schrieb François Van Emelen:

Op 11/10/2016 om 18:15 schreef Ralf Reköndt:

What was the cure?

- Original Message - From: "François Van Emelen"


Sorry for the late reply: I am having some health problems.

Wolfgang found the problem and told me how to solve it.

New timings

Conversion of a DBF-file to a DBS-file (from dos1_ to win2_)

Qpc2 : before correction 1423 sec. after correction 24 sec. (59 x 
faster)


Smsqmulator : before correction 47 sec. after correction 26 sec. 
(1,8 x faster)


Many thanks to Wolfgang.

Have a fine day,

François Van Emelen 


___
QL-Users Mailing List


Hi Ralf,

It was a programming error: an instruction ('update') inside a loop 
that should have been outside that loop. Ihis implied an 'update' 
after each field (in this case 118) instead of only ONE 'update' 
outside the loop. (Is this understandable English?)


Why such an important difference between QPC2 (60x slower) and 
QMSQmulator (1.8x slower)? Wolfgang told me that QMSQmulator uses its 
own 'win-driver'. For more explanation, you 'd better ask Wolfgang or 
Marcel. My skills are limited to some easy Sbasic unfortunately.


Thanks for your reply. that makes 2 listeners on this list :).

François Van Emelen



___
QL-Users Mailing List


___
QL-Users Mailing List

Re: [Ql-Users] Why so slow?

[Alexandre Souza]

And how far people are listening...Greetings from Brazil! :)

2016-10-12 8:38 GMT-03:00 Andreas Berger :

> Am 12.10.2016 um 11:45 schrieb François Van Emelen:
>
> Thanks for your reply. that makes 2 listeners on this list :).
>>
>
> you don't know who all is watching/listening - and only not writing at all
> :-)
>
> regards, Andreas
>
> ___
> QL-Users Mailing List
___
QL-Users Mailing List

Re: [Ql-Users] Why so slow?

[Ralf Reköndt]

Ah, ok, but we have to wait for Marcel to put this into QPC, as he has a 
special SMSQ/E.


- Original Message - 
From: "Wolfgang Lenerz"



Hi,

Put simply, the record "update" forces a flushing of all the buffers for
the file. When using the SMSQ/E routines, this may give rise to writing
several sectors to the disk, one after the other, which is slow. My win
driver handles that a bit differently - there is no  buffer to flush per 
se.


Wolfgang



Hi Ralf,

It was a programming error: an instruction ('update') inside a loop that
should have been outside that loop. Ihis implied an 'update' after each
field (in this case 118) instead of only ONE 'update' outside the loop.
(Is this understandable English?)

Why such an important difference between QPC2 (60x slower) and
QMSQmulator (1.8x slower)? Wolfgang told me that QMSQmulator uses its
own 'win-driver'. For more explanation, you 'd better ask Wolfgang or
Marcel. My skills are limited to some easy Sbasic unfortunately.

Thanks for your reply. that makes 2 listeners on this list :).

François Van Emelen 


___
QL-Users Mailing List

Re: [Ql-Users] Why so slow?

[Wolfgang Lenerz]

Hi,

Put simply, the record "update" forces a flushing of all the buffers for
the file. When using the SMSQ/E routines, this may give rise to writing
several sectors to the disk, one after the other, which is slow. My win
driver handles that a bit differently - there is no  buffer to flush per se.

Wolfgang


> Hi Ralf,
> 
> It was a programming error: an instruction ('update') inside a loop that
> should have been outside that loop. Ihis implied an 'update' after each
> field (in this case 118) instead of only ONE 'update' outside the loop.
> (Is this understandable English?)
> 
> Why such an important difference between QPC2 (60x slower) and
> QMSQmulator (1.8x slower)? Wolfgang told me that QMSQmulator uses its
> own 'win-driver'. For more explanation, you 'd better ask Wolfgang or
> Marcel. My skills are limited to some easy Sbasic unfortunately.
> 
> Thanks for your reply. that makes 2 listeners on this list :).
> 
> François Van Emelen
> 
> 
> 
> ___
> QL-Users Mailing List

___
QL-Users Mailing List

Re: [Ql-Users] Why so slow?

[Andreas Berger]

Am 12.10.2016 um 11:45 schrieb François Van Emelen:


Thanks for your reply. that makes 2 listeners on this list :).


you don't know who all is watching/listening - and only not writing at 
all :-)


regards, Andreas

___
QL-Users Mailing List

Re: [Ql-Users] Why so slow?

[jms1]

Francois your english is good

John

On 2016-10-12 10:45, François Van Emelen wrote:

Op 11/10/2016 om 18:15 schreef Ralf Reköndt:

What was the cure?

- Original Message - From: "François Van Emelen"


Sorry for the late reply: I am having some health problems.

Wolfgang found the problem and told me how to solve it.

New timings

Conversion of a DBF-file to a DBS-file (from dos1_ to win2_)

Qpc2 : before correction 1423 sec. after correction 24 sec. (59 x 
faster)


Smsqmulator : before correction 47 sec. after correction 26 sec. 
(1,8 x faster)


Many thanks to Wolfgang.

Have a fine day,

François Van Emelen


___
QL-Users Mailing List


Hi Ralf,

It was a programming error: an instruction ('update') inside a loop
that should have been outside that loop. Ihis implied an 'update'
after each field (in this case 118) instead of only ONE 'update'
outside the loop. (Is this understandable English?)

Why such an important difference between QPC2 (60x slower) and
QMSQmulator (1.8x slower)? Wolfgang told me that QMSQmulator uses its
own 'win-driver'. For more explanation, you 'd better ask Wolfgang or
Marcel. My skills are limited to some easy Sbasic unfortunately.

Thanks for your reply. that makes 2 listeners on this list :).

François Van Emelen



___
QL-Users Mailing List


___
QL-Users Mailing List

Re: [Ql-Users] Why so slow?

[François Van Emelen]

Op 11/10/2016 om 18:15 schreef Ralf Reköndt:

What was the cure?

- Original Message - From: "François Van Emelen"


Sorry for the late reply: I am having some health problems.

Wolfgang found the problem and told me how to solve it.

New timings

Conversion of a DBF-file to a DBS-file (from dos1_ to win2_)

Qpc2 : before correction 1423 sec. after correction 24 sec. (59 x 
faster)


Smsqmulator : before correction 47 sec. after correction 26 sec. (1,8 
x faster)


Many thanks to Wolfgang.

Have a fine day,

François Van Emelen 


___
QL-Users Mailing List


Hi Ralf,

It was a programming error: an instruction ('update') inside a loop that 
should have been outside that loop. Ihis implied an 'update' after each 
field (in this case 118) instead of only ONE 'update' outside the loop. 
(Is this understandable English?)


Why such an important difference between QPC2 (60x slower) and 
QMSQmulator (1.8x slower)? Wolfgang told me that QMSQmulator uses its 
own 'win-driver'. For more explanation, you 'd better ask Wolfgang or 
Marcel. My skills are limited to some easy Sbasic unfortunately.


Thanks for your reply. that makes 2 listeners on this list :).

François Van Emelen



___
QL-Users Mailing List