Re: performance question

Article View: borland.public.interbase.sql

Article #10984

Back to borland.public.interbase.sql Previous Next

#10984

From: Craig Stuntz TeamB
Date: Thu, 02 Jan 2003 22:37

23 lines
1918 bytes

In article <3e14afef@newsgroups.borland.com>, shg@sion.com says...
> I'm developing a simple purchase order module. The "Search Item" button has
> the code that I post below. It is supposed to run in a client/server network
> with the client in one country and the server in another, via TCP/IP.
> 
> My question: is that the *best-fastest* way to do it?
> 
	The code you have seems fine.  If the table is large you'll get some 
benefit by putting indices on the fields used in the WHERE clause.

	The biggest improvement, in your case, will probably come from using 
a compression program such as a VPN to compress (and probably encrypt) the 
IB over the wire protocol.

	HTH,

	-Craig

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase Perf. Monitor : http://delphi.weblogs.com/IBPerformanceMonitor
InterBase PLANalyzer 1.1: http://delphi.weblogs.com/IBPLANalyzer

Technical Details

Message-ID: <MPG.187e7e3f19cdeaff98a4e4@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3e14afef@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 114a0e,2067f5303db1fb36
X-Google-Attributes: gid114a0e,public
X-Google-ArrivalTime: 2003-01-02 14:40:07 PST
From: Craig Stuntz [TeamB] <cstuntz@nospamplease.com  (but use vertexsoftware to email)>
Newsgroups: borland.public.interbase.sql
Subject: Re: performance question
Date: Thu, 2 Jan 2003 17:37:53 -0500
Message-ID: <MPG.187e7e3f19cdeaff98a4e4@newsgroups.borland.com>
References: <3e14afef@newsgroups.borland.com>
Organization: Vertex Systems Corporation
X-Newsreader: MicroPlanet Gravity v2.60
NNTP-Posting-Host: 65.86.87.242
X-Trace: newsgroups.borland.com 1041547070 65.86.87.242 (2 Jan 2003 14:37:50 -0800)
Lines: 23
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message