Article View: borland.public.interbase.sql
Article #10985Re: performance question
From: Sergio Gonzalez
Date: Thu, 02 Jan 2003 22:56
Date: Thu, 02 Jan 2003 22:56
13 lines
1638 bytes
1638 bytes
Thank you very much Craig! What is VPN ? It's a Delphi's component ? or is a program that must run in the server ? or both? Can you tell where can I learn more of it? Sorry I'm an absolute beginner in Delphi/Interbase! Sergio. > 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.
Technical Details
Message-ID:
<3e14c458$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!newsfeed.tpinternet.pl!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3e14afef@newsgroups.borland.com> <MPG.187e7e3f19cdeaff98a4e4@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 114a0e,2067f5303db1fb36 X-Google-Attributes: gid114a0e,public X-Google-ArrivalTime: 2003-01-02 15:09:38 PST Reply-To: "Sergio Gonzalez" <shg@sion.com> From: "Sergio Gonzalez" <shg@sion.com> Newsgroups: borland.public.interbase.sql References: <3e14afef@newsgroups.borland.com> <MPG.187e7e3f19cdeaff98a4e4@newsgroups.borland.com> Subject: Re: performance question Date: Thu, 2 Jan 2003 19:56:24 -0300 Lines: 16 Organization: SG X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 200.69.36.128 Message-ID: <3e14c458$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1041548376 200.69.36.128 (2 Jan 2003 14:59:36 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!proxad.net!newsfeed.tpinternet.pl!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail