include · ef0b58097f52e1e964ce2117f27515b4648c3441 · docker / osticket

An error occurred while fetching folder content.

Jared Hancock authored 6 years ago

When using a nested query to perform the search for the ticket queue, drop the extra
full-text search criteria join from the outer query. This seems to drop the
`rows_examined` by a factor of two and drops the query time by an order of
magnitude.

ef0b5809

Name	Last commit	Last update
..
cli
client
config
fpdf
i18n
mpdf
pear
plugins
staff
upgrader
.htaccess
JSON.php
PasswordHash.php
Spyc.php
UniversalClassLoader.php
ajax.admin.php
ajax.config.php
ajax.content.php
ajax.draft.php
ajax.filter.php
ajax.forms.php
ajax.i18n.php
ajax.kbase.php
ajax.note.php
ajax.orgs.php
ajax.search.php
ajax.sequence.php
ajax.staff.php
ajax.tasks.php
ajax.thread.php
ajax.tickets.php
ajax.tips.php
ajax.upgrader.php
ajax.users.php
api.cron.php
api.tickets.php
class.ajax.php
class.api.php
class.app.php
class.attachment.php
class.auth.php
class.avatar.php
class.banlist.php
class.base32.php
class.canned.php
class.captcha.php
class.category.php
class.charset.php
class.cli.php
class.client.php
class.collaborator.php
class.company.php
class.config.php
class.cron.php
class.crypto.php
class.csrf.php
class.dept.php
class.dispatcher.php
class.draft.php
class.dynamic_forms.php
class.email.php
class.error.php
class.export.php
class.faq.php
class.file.php
class.filter.php
class.filter_action.php
class.format.php
class.forms.php
class.http.php
class.i18n.php
class.import.php
class.json.php
class.knowledgebase.php
class.list.php
class.lock.php
class.log.php
class.mailer.php
class.mailfetch.php
class.mailparse.php
class.message.php
class.migrater.php
class.misc.php
class.model.php
class.nav.php
class.note.php
class.organization.php
class.orm.php
class.osticket.php
class.ostsession.php
class.page.php
class.pagenate.php
class.passwd.php
class.pdf.php
class.plugin.php
class.priority.php
class.queue.php
class.report.php
class.role.php
class.search.php