Tim

I've been optimising this query

select distinct contacts._ID from
contacts
left join eln on contacts._id = eln._fkcontacts
where
attachsearch(_alist,_encoded,'contains the words','watling','Y')
and
_surname = 'watling'

attachsearch is an external function which scans email attachments. As shown above it takes about 5 seconds (which I'm very happy with).

typed without the left (as I always used to in my DBISAM days) it takes about 90 secs which is about the same if I use inner ditto for right outer join.

So what does JOIN default to?

Also I tried reading the stuff in the manual in the SELECT bit about joins and either my brain has definitely packed in or the manual doesn't make sense. If its my brain please someone try explaining to me.


Roy Lambert

Roy,

<< typed without the left (as I always used to in my DBISAM days) it takes
about 90 secs which is about the same if I use inner ditto for right outer
join.

So what does JOIN default to? >>

INNER.

<< Also I tried reading the stuff in the manual in the SELECT bit about
joins and either my brain has definitely packed in or the manual doesn't
make sense. If its my brain please someone try explaining to me. >>

Which part of the manual topic doesn't make sense ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< typed without the left (as I always used to in my DBISAM days) it takes
>about 90 secs which is about the same if I use inner ditto for right outer
>join.
>
>So what does JOIN default to? >>
>
>INNER.

Out of interest was that wat it was in DBISAM?

><< Also I tried reading the stuff in the manual in the SELECT bit about
>joins and either my brain has definitely packed in or the manual doesn't
>make sense. If its my brain please someone try explaining to me. >>
>
>Which part of the manual topic doesn't make sense ?

My brain had packed in! No surprise there after the sort of day I'd been having - I'd turned to coding for some light relief. Trying again just now the problem was that no matter how many times I read it I never managed to spot the words "target" and "source" and since the rest of the text is almost word for word identical my brain imploded.

Roy Lambert

Roy,

<< Out of interest was that wat it was in DBISAM? >>

Yep, it's the standard.

<< My brain had packed in! No surprise there after the sort of day I'd been
having - I'd turned to coding for some light relief. >>

Well, there's your problem.  Here's the corrected version:

My brain had packed in! No surprise there after the sort of day I'd been
having - I'd turned to a beer for some light relief.

It's usually a bad idea to turn to coding for mental relief.

--
Tim Young
Elevate Software
www.elevatesoft.com