Hi Dave,
It speeds it up a little bit but it's still taking anywhere from 4-6 seconds on my system. Any other ideas?
I put the following indexes on the logger tables.
CREATE INDEX logger_variables_package_id_inx ON logger_variables(package_id);
CREATE INDEX logger_projects_inx ON logger_projects(project_lead);
CREATE INDEX logger_projections_variable_id_inx ON logger_projections(variable_id);
CREATE INDEX logger_projections_project_id_inx ON logger_projections(project_id);
CREATE INDEX logger_project_var_map_variable_id_inx ON logger_project_var_map(variable_id);
CREATE INDEX logger_project_pkg_map_package_id_inx ON logger_project_pkg_map(package_id);
CREATE INDEX logger_entries_variable_id_inx ON logger_entries(variable_id);
CREATE INDEX logger_entries_project_id_inx ON logger_entries(project_id);
