DBA and long-running queries
Wednesday, 10 June 2015 · 2 messages
KK
Kristian Kankainen10 Jun 2015 09:59 #
I want to add a big (150mb) xml file as a resource to my database. The machine is behind a reverse proxy, so the easiest way would be through the DBA. I have the file locally on the same machine I run Tomcat on, but when I run the
db:add() query, I get a timeout (504 Gateway Time-out 504 Gateway Time-out nginx/1.2.1).
Is there a way of circumventing this? Perhaps instead of running the db:add() straight from the DBA, I should have it as a function in my XQrepo and trigger it somehow?
KristianCG
Christian Grün10 Jun 2015 10:03 #
Hi Kristian,
Quoted text · Kristian Kankainen · 5 lines
> I want to add a big (150mb) xml file as a resource to my database. The > machine is behind a reverse proxy, so the easiest way would be through the > DBA. I have the file locally on the same machine I run Tomcat on, but when I > run the db:add() query, I get a timeout (504 Gateway Time-out 504 Gateway > Time-out nginx/1.2.1).
Have you tried to tweak the nginx/Tomcat settings?
Christian
Written for BaseX 8.2. BaseX may have changed since: please check the current documentation.
⚡Generated with XQuery