• Content count

  • Joined

  • Last visited

  • Days Won


flydev last won the day on April 6

flydev had the most liked content!

Community Reputation

989 Excellent


About flydev

  • Rank
    Hero Member
  • Birthday 09/21/1983

Profile Information

  • Gender
  • Location

Recent Profile Visitors

2,479 profile views
  1. I just took a look at the number of pages I got into the system, there is 407446 pages found, expecting around 1.2M pages at the end of the year. I didn't got the time to test your module again deeper but it look promising. The only thing I am scratching my head in, its the calculation of multiple fields on 100K+ pages at one time... Did you tried something already ? Actually, doing some calculation on 119k pages on one go take about 19seconds and rendering a chart from this number of pages take about two or three minutes! 🙈
  2. Hi @Karl_T sorry for that and thanks for reporting this issue, I think I have an idea why is happening - checking this afternoon.
  3. Hi, Double check that you are not sending the email to a domain out of your control. Double check your SPAM folder If you use a Google account, you have to disable a security option on your account Read this thread and get back to us
  4. Stuck to delayed output for a while before using to a template engine, I really should give a try to markup region with it. A quick ref for myself:
  5. you can just put a get variable ?register=1 on the request and it will show the registration form..
  6. If you put namespace ProcessWire; on top of the module file, does it work ?
  7. I Will make a thread 👍
  8. I finally found my mistake - it was an autoload module. Also another mistake was the selector. I was using the has_parent keyword on a ~360k pages, growing each night. Selecting a direct parent reduced considerably the time of the aggregation. It take ~18 seconds to do some calculation on 112 689 pages fetched, but it take 60 seconds to build and show two charts from theses 112k pages. Still looking to improve it before scratching my head into MySQL stocked procedures. Didn't checked the repo, do you have pushed an update regarding the implementation in RockSqlFinder yet ? okay
  10. Okay, Not sure how to debug the right query in the module, but The findIDs() in buildQuery(), in the DBMS take 0.3087 second for 18119 pages. The query ($query) in findObjects(), in the DBMS take 1.9846 seconds for 18119 pages. And, why we have a difference of ~10 seconds when calling findObjects() or even findMany() from Tracy ? Edit 1: same average with 96611 pages. Edit 2 : I stumbled on this thread : If you are interested, I have the code of two hooks which implement COUNT(), SUM() and DATEDIFF().
  11. I don't want to pollute your official thread so I post here. Perhaps you have an idea before I go further in my questions I have a template which contain some fields. Two of them are timestamp, rest are integer. What I want is to fetch pages that are in a date range, so I have this selector : In this example, the system fetch 18119 pages. Results : It take around 10 seconds to fetch all pages, in the DBMS it take 0.3908 second(s) for 18119 pages. I think I am missing something
  12. Thanks for this module @bernhard , I am going to test it heavily today. In the project I built, similar to what you showed us, we are calling 30,000 pages to 100,000 pages per iteration (17 atm) and doing heavy aggregation on it to generate statistics and chart - a pain, hopefully fixed with your module. At this moment I am using this module quite modified for my need which add custom functions to the Page object by hooking it. I think that today I will re-write my hooks using your module. Feedback coming. Thanks again for the work and congratulation 👍
  13. Maybe you could provide a Gulp tasks file along the module which could be called and generate a rockdatatables.min.js/css.
  14. If you are not using TracyDebugger, then I urge you to install it then debug both variables, you will find your answer
  15. The value of the Inputfield is set from an user trough the module config page ? If yes (I dont know how your module work) , then imagine the following, in the getDefaultData() you have : protected static function getDefaultData() { return array( 'ml_myfield_data' => '' ); } In your getModuleConfigInputfields() : public static function getModuleConfigInputfields(array $data) { $data = array_merge(self::getDefaultData(), $data); // [...] $f = $modules->get("InputfieldCKEditor"); $f->attr('name', 'ml_myfield_data'); $f->value = $data['ml_myfield_data']; $f->useLanguages = true; // [...] } Then in module ready() (for testing purpose) you can return the right language : if($this->wire('languages')) { $userLanguage = $this->wire('user')->language; $lang = $userLanguage->isDefault() ? '' : "__$userLanguage->id"; } else { $lang = ''; } bd($this->data['ml_myfield_data'.$lang]); // debug with tracy After you change your language in your profile, it should return the right language.