Member Avatar for javedsai

Hi everyone,

Now a days Justhost & Bluehost are putting restrictions on mysql joins. Even If there are 11 or 12 Joins the query is not running. When you will run the same query in phpmyadmin then, its giving you error message as "#1104 - The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay". Is there any way to come out of this situation. My site is fully cms and you all know that, in cms there are lot of joins and queries.

Kindly, suggest me

  • 2 Contributors
  • 1 Reply
  • 73 Views
  • 35 Minutes Discussion Span
  • Latest Post Latest Post by veedeoo
Member Avatar for veedeoo

Try reading this Article entitled Minimize Bandwith in One-to-Many Joins. If it doesn't worked out for you, maybe it's time to move on and find another hosting company.

Edited by veedeoo because: more info added
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.