Open-AudIT

Apolgies for that, will make sure I latest version before amending it in future.
I am on a couple of days hols at the moment, but will see if I can do the same tweaks on this latest services query when I get back in the office.

I have now modified the services query to use joins, performance is now much better, see attached file.
On the same topic searching for a common string such as 'microsoft' causes a memory exhausted error, presumably because of the number of rows returned, I will have a think and see if there is a way I can trap this and return a more sensible message, eg, "too many matches, data truncated"

Using your last search.php, every service retrieved is duplicated...

_________________
Edoardo

Sorry about that, I'm not seeing it on mine, however if you change line 246 from UNION ALL to UNION it should fix it.

ie from
$sql .= " UNION ALL ";
to
$sql .= " UNION ";
Make sure you have a space both before and after the word UNION.

Thanks, added to SVN rev. 1115

_________________
Edoardo

I also added the following indexes to the tables, so that we are now joining and searching on indexed fields.
alter table service add index (service_display_name);
alter table service add index (service_name);
alter table service_details add index (sd_display_name);
alter table service_details add index (sd_description);