Paid affiliate hosting advertisement
Hosting which allows sql_big_selects
Bearable - September 17, 2009 - 15:53
Currently using blue-host and have views requiring Sql_big_selects to be turned on. Tech Support says they can not turn it on because it requires too much of their resources. The site I am working on does not have large volume, maybe 50 to 100 subscribers connecting per day but does handle large files, mostly pdfs, and text. My client and most of the subscribers will be in Midwestern USA. and the client is a small business so cost is defiantly an issue. Any suggestions for hosting?
This is really not recommend
This is really not recommend to be turned on even you purchase a dedicated server.
Do you know why you need it?
You can refer to http://dev.mysql.com/doc/refman/5.0/en/server-options.html#option_mysqld... to know the functional of it.
Best Drupal Hosting | Best Web Hosting | Web Hosting Coupon
Adding 2nd flag to view gives error requesting sql_big_selects
I have several views that as soon as a second node flag is added to the relationship and the fields an error warning that sql_big_selects needs to be on appears. Any suggestions?
Bryan Beauvais
Bearable Computer Services
This should be a SQL
This should be a SQL statement issue, can you paste the final SQL statement constructed by View here?
Best Drupal Hosting | Best Web Hosting | Web Hosting Coupon
view sql which generates sql_big_selects error
user warning: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay query:
SELECT DISTINCT(node.nid) AS nid, node_data_field_pro_county.field_pro_county_value AS node_data_field_pro_county_field_pro_county_value, node.type AS node_type, node.vid AS node_vid, flag_content.content_id AS flag_content_content_id, flag_content2.content_id AS flag_content2_content_id FROM node node LEFT JOIN flag_content flag_content_node ON node.nid = flag_content_node.content_id AND flag_content_node.fid = 5 LEFT JOIN flag_content flag_content_node_1 ON node.nid = flag_content_node_1.content_id AND flag_content_node_1.fid = 6 LEFT JOIN content_type_projects node_data_field_pro_county ON node.vid = node_data_field_pro_county.vid LEFT JOIN flag_content flag_content ON node.nid = flag_content.content_id AND flag_content.fid = 5 LEFT JOIN flag_content flag_content2 ON node.nid = flag_content2.content_id AND flag_content2.fid = 6 in /home1/webcbnco/public_html/CBN/sites/all/modules/views/includes/view.inc on line 759.
Bryan Beauvais
Bearable Computer Services
Below is a post to resolve
Below is a post to resolve your problem easily, another ways is to simplify your sql but it's hard to help here withouting knowing what you are going to retrieve.
http://drupal.org/node/361953
Best Drupal Hosting | Best Web Hosting | Web Hosting Coupon