Re: Join takes too much time

Article View: borland.public.interbase.sql

Article #580

Back to borland.public.interbase.sql Previous Next

#580

From: Olivier Peter
Date: Thu, 11 Oct 2007 15:06

16 lines
1293 bytes

Thanks Maxim.

It does work a lot smoother this way.

Olivier Peter

"Maxim Shiryaev" <MaximShiryaev@gmail.com> wrote:
>Hi!
>
>The procedure is executed for each line of the T_EMPLOYEE_GENERAL. And then
>only a portion of its data is used.
>It's better to pass EG.EG_EMPLOYEEID as parameter and use it to filter a
>query inside the procedure.
>
>Maxim.

Technical Details

Message-ID: <470e3bfe$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <47049703$1@newsgroups.borland.com> <4704a9f4$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,cd7986aef1014d63
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Olivier Peter" <peterolivier@hotmail.com>
Sender: "Olivier Peter" <peterolivier@hotmail.com>
Reply-To: "Olivier Peter" <peterolivier@hotmail.com>
Subject: Re: Join takes too much time
Newsgroups: borland.public.interbase.sql
X-User-Info: 213.219.171.30     
References: <47049703$1@newsgroups.borland.com> <4704a9f4$1@newsgroups.borland.com>
NNTP-Posting-Host: 207.105.83.66
Message-ID: <470e3bfe$1@newsgroups.borland.com>
Date: 11 Oct 2007 08:06:38 -0700
X-Trace: newsgroups.borland.com 1192115198 207.105.83.66 (11 Oct 2007 08:06:38 -0700)
Lines: 17
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message