Thanks Tim, I see your point, but if the code is not optimal -
I expect things go slowly every day but what I see is that things
are usually fast but go down in a nasty way twice a week. :)

--- In firebird-support@yahoogroups.com, Tim <tim@...> wrote:
>
> Write better code. :D
>
> (in Delphi terms)
>
> A TTable is a query that returns a subset of ALL the rows in a
table.
> (LOTS of network traffic) When you scroll through the table, it
re -
> runs the query as soon as you go beyond the subset you have asked
for.
>
> A TQuery is a query that (as far as I understand it) returns a
subset
> of what you ask for, plus some rows on either side.
>
> A TStoredProcedure returns EXACTLY what you ask for. Nothing more,
> nothing less.
>
> Now, I'm no expert. I may have the details wrong. (I probably have
> the details wrong :)) But even with that, a stored procedure is
the
> fastest way or returning data AND keeping the network traffic down.
>
> Added to the above, the exact design of your query can also have
an
> effect on network traffic. SELECT * FROM ABC obviously returns
more
> data than SELECT ROWNUMBER, CLIENTNAME from ABC.
>
> HTH
>
> Tim
>
> At 16:07 27/03/2006, you wrote:
>
> >--- In firebird-support@yahoogroups.com, Tim <tim@> wrote:
> > >
> > >
> > > We've had this problem before.
> >
> >I am not alone in this world :)
> >
> >And it has often been because of one
> > > of two reasons :
> > >
> > > faulty network card
> >
> >We will try another one, sure.
> >
> > > network traffic slows down the request to (and response from)
the
> >server
> >
> >What can be done about that other than asking people to work
less? :)
> >
> > >
> > > HTH
> > >
> > > Tim
> > >
> > > At 14:23 27/03/2006, you wrote:
> > >
> > > >Hello,
> > > >
> > > >This is FB1.53 on Win2003 Server and 20-30 simultaneous
Windows
> > > >clients,
> > > >default Firebird configuration is used.
> > > >
> > > >2-3 times a week, the mess starts with one client receiving
this
> > > >message:
> > > >
> > > >Unable to complete network request to host "Server".
> > > >Error writing data to the connection.
> > > >An existing connection was forcibly closed by the remote host.
> > > >
> > > >Which, in turn, leads to other clients (but not all!)
occasionally
> > > >receiving the same message until the server is rebooted.
> > > >
> > > >If you have an idea - please help.
> > > >
> > > >Thank you,
> > > >Glebas
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > >
> > > >Visit
> > >
><<http://firebird.sourceforge.net>http://firebird.sourceforge.net
> > >http://firebird.sourceforge.net
> >and
> > > >click the Resources item
> > > >on the main (top) menu. Try Knowledgebase and FAQ links !
> > > >
> > > >Also search the knowledgebases at
> > >
><<http://www.ibphoenix.com>http://www.ibphoenix.com>http://www.ib
> > phoenix.com
> > > >
> > >
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > > >
> > > >
> > > >
> > > >
> > > >----------
> > > >YAHOO! GROUPS LINKS
> > > >
> > > > * Visit your group
> > > >
> > "<<http://groups.yahoo.com/group/firebird-
support>http://groups.yahoo.com/group/firebird-support>firebird-
> >support" on the web.
> > > > *
> > > > * To unsubscribe from this group, send an email to:
> > > > *
> > > > <mailto:firebird-support-unsubscribe@yahoogroups.com?
> >subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
> > > >
> > > > *
> > > > * Your use of Yahoo! Groups is subject to the
> > > >
> >
<<http://docs.yahoo.com/info/terms/>http://docs.yahoo.com/info/terms/
>Yahoo!
> > Terms of Service.
> > > >
> > > >
> > > >----------
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> >
> >
> >
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >Visit
> ><http://firebird.sourceforge.net>http://firebird.sourceforge.net
and
> >click the Resources item
> >on the main (top) menu. Try Knowledgebase and FAQ links !
> >
> >Also search the knowledgebases at
> ><http://www.ibphoenix.com>http://www.ibphoenix.com
> >
> >++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> >
> >
> >
> >----------
> >YAHOO! GROUPS LINKS
> >
> > * Visit your group
> > "<http://groups.yahoo.com/group/firebird-support>firebird-
support" on the web.
> > *
> > * To unsubscribe from this group, send an email to:
> > *
> > <mailto:firebird-support-unsubscribe@yahoogroups.com?
subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
> >
> > *
> > * Your use of Yahoo! Groups is subject to the
> > <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.
> >
> >
> >----------
>
>
> [Non-text portions of this message have been removed]
>