Hi ,
My question is that is it feasible to use “After Trigger” on piwik_log_visit table .
We are calculating unique new visitors within past 24 hours for every minute .
Current query have to look for every minute within past 24 hours so it is taking time in minutes while we need result in seconds .We are thinking that within trigger we will insert unique visitor into new table and then query will run on new table ,in this way new query have not to check within past 24 hours because new table already have unique new visitors .
Thanks,
Saqib