heremiguel

MySQL Session Variables

Hi everybody! Where is the best place to set the environment variables? DB::statement("SET tmp_...

Another question regarding performance.

I got this query: SELECT (SELECT GenreDescription FROM Genre WHERE GenreId = Reports.ReportGenreId)...

If in statements

Hi everyone, a "simple question" maybe it's not possible... I have this query repeated con...

Question regarding aggregate in Query Builder

I am querying a table and I wonder why Laravel make a count(*) query before my query that spend addi...

I was thinking in another solution, would be possible to store the pagination results in "remem...

Hi, thank you for your help: I made some improvements I removed the join to the User table and creat...

Yes because the table has 2 additional joins and for any reason this joins are included in the count...