--- In firebird-support@yahoogroups.com, Svein Erling Tysvær
svein.erling.tysvaer@... wrote:
Out of interest, does SELECT 1 work identically and if so whether it
performs any quicker (if this were a very large table) than SELECT *
in the sub-select?
In other words, I'm unclear how
On 7-10-2011 11:12, tomc777 wrote:
There's no way subselects can be materialized, at least doing ..
My use of the term 'materialized' may have been misunderstood, it was meant
to relate to whether/how the sub-select row is retrieved and compared when *
vs 1 are used.
I've a copy of
Tomasz,
Conclusion: using select 1 ... instead of select * ... in the sub-select
doesn't
improve anything, while using select first(1) ... even slows things down a
bit.
IMHO, that proves FB handles the sub-selects in an efficient manner, i.e.
doesn't retrieve irrelevant data and exits the
Great
Thank you very much, things are most clear now.
Greetings.
Walter.
On Fri, Oct 7, 2011 at 8:11 AM, Tomasz Tyrakowski
t.tyrakow...@sol-system.pl wrote:
**
Just to make sure, I've prepared a simple experiment to measure if
sub-selects in the EXISTS clause can behave
On 07.10.2011 10:44, sir_wally_lewis wrote:
Has anyone successfully written a pascal UDF
to pass timestamps/strings without using
the ibobjects library?
Yes, what problems do you face?
mit freundlichen Grüßen
Frank Schlottmann-Gödde
--
Fascinating creatures, phoenixes, they can carry
as far as i can see to do the task.
i must import isc_decode_date/isc_encode_date from fbclient library
however as soon as i call a function that connects to these methods the
connection crashes.
also a major hurdle is no real way of debugging the dll as to why
it would cause the firebird
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote:
On 7-10-2011 11:12, tomc777 wrote:
There's no way subselects can be materialized, at least doing ..
My use of the term 'materialized' may have been misunderstood, it was meant
to relate to whether/how the
Sean,
I wasn't trying to find the best way to update a bunch of records, which
have their counterparts in a second table. The original discussion
concerned a question whether there's a point in trying to refine the
sub-select in EXISTS or the straightforward SELECT * ... is the best
option.
I am looking into the feasibility of using Microsoft Sync Framework with
Firebird 2.5 or 3.0. Microsoft SQL Server exposes a concept which I believe
all RDBMS need to have internally, they call it the row version, I am wondering
if this is exposed or could be exposed in Firebird.
Here is what