Clarion Vs. TopSpeed Driver / Speed
Jean-Marc R.
No question here. Just want to express my findings about the TopSpeed driver
after switching from Clarion.
1) On a file with approximately 5000 records, processing the TPS file takes
considerably LONGER than doing the same with the Clarion driver.
2) the same TPS file takes about 2-3 times LESS space than with Clarion
(keys + memo included).
This is what I could not find anywhere in the documentation. Everything else
is pretty much known to everybody.
------------------------------------->
Jean-Marc Rousset
jrou...@hotmail.com
------------------------------------->
Mike Gould
>No question here. Just want to express my findings about the TopSpeed
driver
>after switching from Clarion.
>1) On a file with approximately 5000 records, processing the TPS file takes
>considerably LONGER than doing the same with the Clarion driver.
>2) the same TPS file takes about 2-3 times LESS space than with Clarion
>(keys + memo included).
>
>This is what I could not find anywhere in the documentation. Everything
else
>is pretty much known to everybody.
>
Jean,
I'm not sure which version of CW you are using. In C4, you can now put
STREAM
on in a multi-user mode. This will speed up the processing tremendously.
With
Stream enabled, it should easily out do the Clarion file format.
HTH's
Michael Gould
TopSpeed Corporation - Consulting Divsion
Team TopSpeed - Internet
David Groves
Steve,
On Wed, 17 Dec 1997 04:30:27 GMT, zo...@surfgbs.co.nz (Stephen Ryan)
wrote:
>
>Turn logout on and see if it flies, we added a million records to a
>large keyed file in under an hour.
I'm impressed!
What h/w s/w environment were you using?
>
>Do a commit every so often to clear the buffers.
>
>In the old days the clarion dat files simple couldnt take it at that
>speed.
>
>Steve Ryan
Robert Paresi
Mike,
Didn't know C4 changed STREAM for multi-user.
But, I have a question ... I have a process which does a lot of
adding/updating for dayend - like 400 records with the following:
accountcode=x
get(accounts,accountkey)
if errorcode()
add(accounts)
else
put(accounts)
end
Is it just as safe to use Stream in a PUT and DELETE just as well as
something with stictly ADDs?
--
---
Robert Paresi
InnQuest Software
http://www.innquest.com
[Using Outlook Express 4.01, C4B5]
Mike Gould wrote in message <3495e...@fortress.uccb.ns.ca>...
Computer Discount Center
Activate STREAM before processing the file. You will find the Topspeed
driver will outrun the Clarion driver big time.
--
Best Regards,
Jerry P. Ray - Hard at Work
Computer Discount Center
Home of the Computer Doctors
Email: jr...@aug.com -or- c...@aug.com
Jean-Marc R. wrote in message <674mqs$s...@world5.bellatlantic.net>...
George Barwood
>Didn't know C4 changed STREAM for multi-user.
>
>But, I have a question ... I have a process which does a lot of
>adding/updating for dayend - like 400 records with the following:
>
>accountcode=x
>get(accounts,accountkey)
>if errorcode()
> add(accounts)
>else
> put(accounts)
>end
>
>Is it just as safe to use Stream in a PUT and DELETE just as well as
>something with stictly ADDs?
Yes, Stream is fine here. You should use LOGOUT instead of STREAM when
there is more than 1 file involved ( to avoid possible deadlock
problems ).
In C4 there is a nice new feature which means that read access is
still possible to Topspeed files logged out (or STREAMed) by another
station.
George
Stephen Ryan
"Jean-Marc R." <com...@bellatlantic.net> wrote:
>No question here. Just want to express my findings about the TopSpeed driver
>after switching from Clarion.
>1) On a file with approximately 5000 records, processing the TPS file takes
>considerably LONGER than doing the same with the Clarion driver.
>2) the same TPS file takes about 2-3 times LESS space than with Clarion
>(keys + memo included).
Turn logout on and see if it flies, we added a million records to a
large keyed file in under an hour.
Do a commit every so often to clear the buffers.
In the old days the clarion dat files simple couldnt take it at that
speed.
Steve Ryan
>This is what I could not find anywhere in the documentation. Everything else
>is pretty much known to everybody.
>------------------------------------->
>Jean-Marc Rousset
>jrou...@hotmail.com
>------------------------------------->