Clarion slow over network?

Alexandar Kolaric

unread,

Mar 9, 2003, 5:08:36 AM3/9/03

to

Hi everyone,

We have a problem with our application that uses TPS files. We have file
with 50000 records which we must browse and create some totals. On machine
where the TPS files resides (1.2 Ghz processor) we get results in 10-15 secs
and through the 100Mbit network we wait for results as much as 10 minutes
(sometimes more). Can anyone give me some suggestion? Is this related to
Clarion or network? I must state at this time that copying files through the
network is working like a charm. We tried to reduce the network traffic for
test purposes by using only two PCs but the results are the same.

The problem is getting much bigger when we filter files or use files with 1
000 000 records or more.

Any help will be appreciated.

Best regards,
Alex

Henrik Kartin

unread,

Mar 9, 2003, 5:35:57 AM3/9/03

to

Loose the the filter and the totals and see what happens. I had the same
problems until I started using keys instead of filters. The problem is that
when you use the filter all records are copied over the network and the
filtering is done on the local PC. When you use a key only the records that
meet the range limit are copied over the network and everything will work
faster.
The automatisk totalling on the browse is just to slow. I don't know why.

Hope it helps!

Regards,

Henrik Kartin
Kartin Data
Denmark

h...@kartindata.dk

"Alexandar Kolaric" <con...@verat.net> skrev i en meddelelse
news:3e6b...@news.softvelocity.com...

Alexandar Kolaric

unread,

Mar 9, 2003, 7:06:38 AM3/9/03

to

Hi Henrik,

Thanks for your quick help. I'll try and see what results will I get.

Best regards,
Alex

"Henrik Kartin" <h...@kartindata.dk> wrote in message
news:3e6b193c$0$52102$edfa...@dread16.news.tele.dk...

Ron Schofield

unread,

Mar 9, 2003, 10:02:43 AM3/9/03

to

Which NOS are you using?

Bob Campbell

unread,

Mar 9, 2003, 11:07:52 AM3/9/03

to

I give the user the option to have filters and/or totals. I put a checkbox
on the browse screen which is off by default, and of course it runs fast.

"Alexandar Kolaric" <con...@verat.net> wrote in message
news:3e6b...@news.softvelocity.com...

Bruce Johnson

unread,

Mar 9, 2003, 12:10:49 PM3/9/03

to

> The automatisk totalling on the browse is just to slow. I don't know why.

For exactly the same reason that the filter is slow - it has to read all the
records, and then calc the total.

Cheers
Bruce

"Henrik Kartin" <h...@kartindata.dk> wrote in message
news:3e6b193c$0$52102$edfa...@dread16.news.tele.dk...

Alexandar Kolaric

unread,

Mar 9, 2003, 12:27:39 PM3/9/03

to

We have many different (in terms of OS) sites where our app works but the
problem stays the same. Mostly Win2000, Win98 or XP clients using TCP\IP
protocol. We got better results with manualy configured IPX\SPX protocol and
NetBEUI.

Still we are having great problems when it comes to generating screen
reports on large databases.

Our client has more than 1 500 000 records in only one table and our
software is operating with more than 250 tables currently. They are
expecting this number of transactions in first quater this year and we must
do something to speed up reporting with this data.

Best regards,
Alex

"Ron Schofield" <r...@schofieldcomputer.com> wrote in message
news:3E6B5793...@schofieldcomputer.com...

Erik Schwarz

unread,

Mar 10, 2003, 3:09:30 AM3/10/03

to

Hi,

maybe you have the same problem than I another guy from Germany, but we
still did not get it solved. Because my client is far away from me, I have
no possibilities to make quick and intensive tests. The network cannot be
the problem in general, because 100MBit is faster or nearly as fast as
direct access to harddisk. It must have to do with a special configuration
of the network or network card.
My client got a new PC and from this point on access was incredible slow.
All other workstations are fast as ever. Removing the PC with a Laptop,
access is fast again. I am assuming it's the configuration of the network
card, but I don't know what to do.
Another client had have the same problem after installing a new PC. Then he
run a tool from another software supplier, and speed is there without
changing anything else, so I am rather sure, it must be some configuration,
but what?
Maybe this hints may help you. If you have success, I would be glad if you
tell me by this forum and personally to my email: erik.s...@oz-sdt.de .
Thanks

Erik

"Alexandar Kolaric" <con...@verat.net> schrieb im Newsbeitrag
news:3e6b...@news.softvelocity.com...

Erik Schwarz

unread,

Mar 10, 2003, 3:15:54 AM3/10/03

to

Once again,
I forgot to mention, I think the problem is, because access to tps is, that
it reads one record after another. When copying a file, speed is still fast.
So my idea:
It takes some time to make a connection to the other PC, say 10ms for
example.
Copying then is instant with speed of network.
I suppose, when configuration is wrong, then the network card makes a new
connection for every record that will be read. So if you have 1000 records
it would be10000ms for connection (equals 10s). When configuration is o.k.
then the connection will be once and held until all records are read and is
closed when timeout or closing the file occurs.
Maybe this thoughts will another little bit.

Erik

"Erik Schwarz" <ne...@oz-sdt.de> schrieb im Newsbeitrag
news:b4hh5m$33f$1...@news.online.de...

CONMAG

unread,

Mar 10, 2003, 7:46:32 AM3/10/03

to Erik Schwarz

Hi Erik,

Thanks for quick answer. We are currently in process of testing network
equipment (cards, switches, packet size etc). If we find something interesting I
would be glad to share it with comunity :)))

Best regards,
Alex

Ron Schofield

unread,

Mar 10, 2003, 8:31:44 AM3/10/03

to

Alex,

You can use the benchmark I created to test TPS files.

http://www.schofieldcomputer.com/cgi-bin/downloads.cgi?dir=/benchmarks

Ron

Peter Pronk Modest Automatisering

unread,

Mar 10, 2003, 9:54:36 AM3/10/03

to

Hi Alex,

We noticed the same problem. But if you are the only user things go very
fast at once. I suppose there's some MU locking mechanism that prevents the
data from showing itself fast enough not to get bored. There's also this
write behind stuff that we had to do in order to work around a "feature" in
NT4 server. Changing these registry settings on and off make a lot of
difference. However, as we had no answere, we changed to MS-SQL. Still I
would like to know what exactly causes this slowness.

Regards,
Peter Pronk, Modest Automatisering

"Alexandar Kolaric" <con...@verat.net> schreef in bericht
news:3e6b...@news.softvelocity.com...

Alexandar Kolaric

unread,

Mar 10, 2003, 12:10:09 PM3/10/03

to

Hi Ron,

Thanks I'll try it

Best regards,
Alex

"Ron Schofield" <r...@schofieldcomputer.com> wrote in message

news:3E6C93C0...@schofieldcomputer.com...

Denis

unread,

Mar 15, 2003, 7:08:54 PM3/15/03

to

Alexandar Kolaric wrote:
> Hi everyone,
>
> We have a problem with our application that uses TPS files. We have file
> with 50000 records which we must browse and create some totals. On machine
> where the TPS files resides (1.2 Ghz processor) we get results in 10-15 secs
> and through the 100Mbit network we wait for results as much as 10 minutes
> (sometimes more). Can anyone give me some suggestion? Is this related to
> Clarion or network? I must state at this time that copying files through the
> network is working like a charm. We tried to reduce the network traffic for
> test purposes by using only two PCs but the results are the same.

There is a technique i use when I deal with slow tps network
application. Instead of using browsr or report templates, i do my own
code. I create a queue and a piece of code that fills the queue from the
database and finally the queue is displayed in a list box.
Works much faster than the ordinary way.

Peter Wensink

unread,

Jun 14, 2003, 3:56:02 PM6/14/03

to

Hi Denis,

Do you have a example of such code ?

Regards, Peter.

"Denis" <d...@dm.com> wrote in message news:3E73C096...@dm.com...