I'm sure the convience of having the reports emailed on a specific day is
what you're looking for. But why not just code your PHP to do your
mysql_query() and mail() and place it on a webserver. Obviously have a
simple hardcoded login so just not anyone can request the reports. That way
your boss
...and the query completes in under 2 secs. Stupidly obvious now but I
thought I would share this blinding insight with the list ;)
Thanks again for all your help.
cheers
jb
Paul Condon wrote:
>
> The example you give, LIKE 'MAIN%', should be able to use the index, but I'm
Thank you both for the suggestions. I did not realize that 'vacuum
analyse' was nesessary to get the indexes working. That alone cut the
search time almost in half. I'll do the ram bit as well.
cheers
jb
"Culberson, Philip" wrote:
>
> JB,
>
> The 20 secon
all the
names, hoping tht would help. I wondered if I'd used the wrong index
type (btree), or if there were some flags that would help. Is there a
way to bust the indexes out alpha on the first letter say, or some other
such scheme. BTW the machine is RH6.1 with 128mb ram, 27 GB, P350, no X
and n
