I mix views and tables in joins all the time - it's very fast (IB6)
Alan
-----Original Message-----
From: Thomas Miller [mailto:tmiller@...]
Sent: Wednesday, 20 November 2002 6:54
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] slow left join on a view.


Form what I remember with IB 6 is that mixing views and tables in join
statements was
very very slow. I would recommend making another view that includes the
additional
table.

Samy Song wrote:

>Did anyone had this problem, I'm trying to do a select with a left join

on a

>view with Firebird, also tested it on Interbase here is the case:
>First select, contacts_view is a view with 3 tables left joined : city,
>province and country.
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]