504 Gateway Time-out. Generating Data.
Dear Colleagues! I have a big data for like 400k items. I am experiencing error message which *"504 Gateway Time-out The server didn't respond in time." * when generation a bunch of data using SQL report module. We also tried optimizing our apace to lengthen the timeout and still it did not resolve the dilemma. On the other hand once we limit the report to lessen the data, it works well. Please advice... Thank you and best regards! -- View this message in context: http://koha.1045719.n5.nabble.com/504-Gateway-Time-out-Generating-Data-tp584... Sent from the Koha-general mailing list archive at Nabble.com.
Hi Jerwyn, On Mon, Jul 27, 2015 at 12:34 PM, Jerwyn <os.jerwynfernandez@gmail.com> wrote:
I am experiencing error message which *"504 Gateway Time-out The server didn't respond in time." * when generation a bunch of data using SQL report module.
We also tried optimizing our apace to lengthen the timeout and still it did not resolve the dilemma. On the other hand once we limit the report to lessen the data, it works well.
http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html http://wiki.koha-community.org/wiki/Profiling_with_Devel::NYTProf hope this helps -- Indranil Das Gupta Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards. For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
Thank you for this brother! Actually we are currently working on this http://wiki.koha-community.org/wiki/Koha_Tuning_Guide Any inputs? Kind regards, On Mon, Jul 27, 2015 at 3:21 PM, Indranil Das Gupta <indradg@gmail.com> wrote:
Hi Jerwyn,
On Mon, Jul 27, 2015 at 12:34 PM, Jerwyn <os.jerwynfernandez@gmail.com> wrote:
I am experiencing error message which *"504 Gateway Time-out The server didn't respond in time." * when generation a bunch of data using SQL report module.
We also tried optimizing our apace to lengthen the timeout and still it did not resolve the dilemma. On the other hand once we limit the report to lessen the data, it works well.
http://dev.mysql.com/doc/refman/5.0/en/show-profiles.html
http://wiki.koha-community.org/wiki/Profiling_with_Devel::NYTProf
hope this helps
-- Indranil Das Gupta
Phone : +91-98300-20971 Blog : http://indradg.randomink.org/blog IRC : indradg on irc://irc.freenode.net Twitter : indradg
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=- Please exchange editable Office documents only in ODF Format. No other format is acceptable. Support Open Standards.
For a free editor supporting ODF, please visit LibreOffice - http://www.documentfoundation.org
-- - Jerwyn Fernandez, RL Koha Support Specialist OS Library Solutions​​ (63) 9336734607 (02) 7383209
participants (3)
-
Indranil Das Gupta -
Jerwyn -
Jerwyn Fernandez