spatie / activitylog

A very simple activity logger to monitor the users of your website or application
https://spatie.be/opensource/laravel
MIT License
582 stars 75 forks source link

Improvement: create an index on created_at #39

Closed MarcosBL closed 8 years ago

MarcosBL commented 8 years ago

As most read queries will be in the form of

select * from `activity_log` order by `created_at` desc limit 50

creating an index on the "created_at" field can speed things up

freekmurze commented 8 years ago

I'll add the index in the next major version of this package which will be released soon.