1. 13 Feb, 2019 1 commit
  2. 11 Dec, 2018 2 commits
  3. 29 Aug, 2018 4 commits
    • ZMySQLDA: Optimise date & datetime parsing in results. · 01e14257
      A pprofile run shows DateTime_or_None costing 3ms per value (including all
      callees).
      While this may seem low, it is common to receive hundreds of such values
      in single query results (ex: web mode document & webpage lookups),
      so the total time spent parting dates per query can become significantly
      larger than the time to execute the query itself.
      In the case of this measure setup, 504 dates were processed for a total of
      1.5 seconds.
      DateTime is slow to parse strings because it cannot rely on a pre-known
      format. With MySQL/MariaDB, the format is know for those column types, so
      implement specific parsing to get better performance.
      On the same setup, pprofile run shows a parsing time of 123µs per value in
      DATETIME_to_DateTime_or_None, or 65ms total.
      DATE_to_DateTime_or_None should not deviate significantly from this.
      Vincent Pelletier committed
    • Revert "ZMySQLDA: Optimise date & datetime parsing in results." · 2dc4c674
      For some reason, unit tests all broke while testing this revision. The
      relation between both is not clear to me (this code has worked for me).
      In doubt, I revert it for now.
      This reverts commit 0057272c.
      Vincent Pelletier committed
    • ZMySQLDA: Optimise date & datetime parsing in results. · 0057272c
      A pprofile run shows DateTime_or_None costing 3ms per value (including all
      callees).
      While this may seem low, it is common to receive hundreds of such values
      in single query results (ex: web mode document & webpage lookups),
      so the total time spent parting dates per query can become significantly
      larger than the time to execute the query itself.
      In the case of this measure setup, 504 dates were processed for a total of
      1.5 seconds.
      DateTime is slow to parse strings because it cannot rely on a pre-known
      format. With MySQL/MariaDB, the format is know for those column types, so
      implement specific parsing to get better performance.
      On the same setup, pprofile run shows a parsing time of 72µs per value in
      DATETIME_to_DateTime_or_None, or 39ms total.
      DATE_to_DateTime_or_None should not deviate significantly from this.
      Vincent Pelletier committed
  4. 29 Aug, 2017 1 commit
  5. 03 Jul, 2017 1 commit
  6. 22 May, 2017 4 commits
  7. 12 Jan, 2016 1 commit
  8. 31 Mar, 2015 1 commit
  9. 10 Mar, 2015 1 commit
  10. 16 Jan, 2015 1 commit
  11. 15 Jan, 2015 1 commit
  12. 08 Nov, 2014 1 commit
    • use fulltext search in title and description. · d47df833
      * to quickly setup catalog_full_text table, you can use the following SQL.
      
        REPLACE INTO catalog_full_text SELECT uid, title, description FROM catalog;
      
      * non fulltext queries like '=abc', '>abc', '%abc%' are supported.
      
      * now erp5_full_text_mroonga_catalog is used for unit tests thus I recommend using it instead of erp5_full_text_myisam_catalog.
      
      * to migrate existing MyISAM full_text table into Mroonga, you can use the following SQL.
      
        ALTER TABLE full_text DROP KEY SearchableText,
          ENGINE = mroonga,
          ADD FULLTEXT KEY SearchableText (`SearchableText`) COMMENT 'parser "TokenBigramSplitSymbolAlpha"';
      
      * fulltext search score is no longer provided as (column_name) but now provided as (column_name)__score__.
      
      * (category)_title, like source_title, related keys are automatically generated. (category)_description keys as well.
      Kazuhiko Shiozaki committed
  13. 04 Sep, 2014 1 commit
  14. 02 Apr, 2013 1 commit
  15. 08 Mar, 2013 1 commit
  16. 28 Feb, 2013 2 commits
  17. 21 Feb, 2013 5 commits
  18. 15 Feb, 2013 1 commit
  19. 19 Sep, 2012 1 commit
  20. 13 Jan, 2012 2 commits
  21. 07 May, 2011 1 commit
  22. 09 Aug, 2010 1 commit
  23. 02 Aug, 2010 1 commit
  24. 26 Jul, 2010 2 commits
  25. 24 Jul, 2010 2 commits