Portal Home > Knowledgebase > Articles Database > increase the length of query string
increase the length of query string
| Posted by prashant1979, 07-25-2011, 03:37 AM |
| How to increase the length of query string for a website developed in PHP and MySQL and running on Linux?
|
| Posted by foobic, 07-25-2011, 04:07 AM |
| What limit are you hitting? And are you referring to the url query string or the php-mysql query string (or something else)?
In any event the best option is probably to change your code so you don't need to increase the length of query string beyond standard limits (eg. use http post or split up your mysql queries).
|
| Posted by prashant1979, 07-25-2011, 06:36 AM |
| I want to know what is the standard limit and up to what limit is recommended to be set.
|
| Posted by drspliff, 07-25-2011, 08:55 AM |
| The limit is almost always enforced at the client side and varies between browsers. The Boutell.com FAQ covering maximum URL length.
You know - 1 minute of internet searching would've given you all the information you need... maybe you should try & use your brain next time rather than having WebHostingTalk users to google stuff for you.
|
| Posted by prashant1979, 07-26-2011, 01:23 AM |
| Before advising people on using Google, I think you need to contain your excitement and read carefully what I am searching for. I need the default value of the maximum query length in MySQL and the recommended value. What you have given me is the maximum length of a URL. About people searching on Google for an answer for me, what is wrong in that? I have myself used Google to find answers for people's queries in WHT. If you don't wanna help, it is better not to reply to the thread. If your intention is just to increase your posts, then I don't need your help.
|
| Posted by prashant1979, 07-26-2011, 07:51 AM |
| While searching on the net, I get details on max allowed packet size. Is it the same as Max query length?
|
| Posted by prashant1979, 07-26-2011, 08:46 AM |
| I found max_allowed_packet is the setting that should be enabled in the my.cnf for setting the maximum query length. The default value is 1 MB. I have set 16 MB for mine.
|
Add to Favourites 
Print this Article
Also Read
Smtp (Views: 520)