Hi, I noticed that now with version 1.11.x (stable) it takes much longer to open the closed queue.

While before with version 1.10 it too very short, now it takes exactly 16 seconds to open. Does it have to do because we have 126941 tickets in our system? But since it was not like that with version 1.10, I assume there might be some more database checks or something which slows it down?

Any idea how to increase the speed?

@AR84

That's very strange as we addressed issues with large data sets specifically with v1.11. All our production sites (some running with millions of closed tickets, yes, millions) are running v1.11 and it's working/loading/performing just fine.

  • Maybe it's a server resource issue?
  • When and where did you download v1.11?

Cheers.

  • AR84 replied to this.

    KevinTheJedi
    I downloaded the February 12th from your official website. It is the stable release that was published.
    What I did was, I moved the excisting version to a new server, upgraded it with the new version and then also changed that it should "store to filesystem" by using the plugin.
    I dont think it is a resource issue of the server since the server is running max 2-3% capacity (CPU, RAM...).
    Could it be because I also changed to the file system storage?

    By the way, I noticed that the migration script does not work to move databased attachments to the file system. I can the following command:

    php setup/cli/manage.php file migrate --backend D --to F

    The error I receive is the following:

    #!/usr/bin/env php
    PHP Warning: ini_set(): Headers already sent. You cannot change the session module's ini settings at this time in /var/www/ticketsystem/bootstrap.php on line 19
    PHP Warning: session_cache_limiter(): Cannot change cache limiter when headers already sent in /var/www/ticketsystem/bootstrap.php on line 21
    PHP Warning: session_set_save_handler(): Cannot change save handler when headers already sent in /var/www/ticketsystem/manage.php on line 28
    PHP Fatal error: Uncaught Error: Call to a member function logError() on null in /var/www/ticketsystem/include/class.error.php:33
    Stack trace:
    #0 phar:///var/www/ticketsystem/include/plugins/storage-fs.phar/storage.php(19): BaseError->__construct('(root)/attachme...')
    #1 /var/www/ticketsystem/include/class.file.php(555): FilesystemStorage->read()
    #2 /var/www/ticketsystem/include/cli/modules/file.php(187): AttachmentFile->migrate('F')
    #3 /var/www/ticketsystem/include/class.cli.php(240): FileManager->run(Array, Array)
    #4 /var/www/ticketsystem/manage.php(74): Module->run('file')
    #5 /var/www/ticketsystem/include/class.cli.php(240): Manager->run(Array, Array)
    #6 /var/www/ticketsystem/manage.php(83): Module->
    run('manage.php', false)
    #7 /var/www/ticketsystem/setup/cli/manage.php(3): include('/var/www/ticket...')
    #8 {main}
    thrown in /var/www/ticketsystem/include/class.error.php on line 33

    Any idea what could be the reason?

    KevinTheJedi
    Thanks, but shouldnt the attachments be transfered out of the database only to the file system?
    Now I actually have much less space on my harddrive since the it migrated "Migrated 49364 files" but they are also still in the database as it seems by the size of the database.

    Write a Reply...