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]