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...

Hi, Use DB:raw like this: DB::table( DB::raw('TABLENAME FORCE INDEX (PRIMARY)') ) Replace TABLENAME...

Hi Citti code and db are in different servers.

Changing the order by field it takes less time to execute BUT I need the order by other field. SELEC...

Hi mate, I am having same issues and nobody answer anything. Have you found anything to improve the...

Note: Everything is correct using explain for this mysql.