Support the ongoing development of Laravel.io →

heremiguel

Joined 29 Jan 2015

Statistics

Threads 4
Replies 13
Solutions 1
Articles 0
posted 7 years ago

MySQL Session Variables

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

Likes Replies

Another question regarding performance.

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

Likes Replies

If in statements

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

Likes Replies
Solved

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

Likes Replies
replied 7 years ago

How to write index hint with Query Builder?

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

0 Likes
replied 7 years ago

Another question regarding performance.

Hi Citti code and db are in different servers.

0 Likes
replied 7 years ago

Another question regarding performance.

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

0 Likes
replied 7 years ago

slow mysql queries when connecting to a remote server, not localhost

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

0 Likes
replied 7 years ago

Another question regarding performance.

Note: Everything is correct using explain for this mysql.

0 Likes

We'd like to thank these amazing companies for supporting us

Your logo here?

The Laravel portal for problem solving, knowledge sharing and community building.

© 2022 Laravel.io - All rights reserved.