Hm, no idea what that could be. My personal assumption is that this is nothing directly related to BaseX; but I may well be wrong. ___________________________
On Fri, Feb 22, 2013 at 5:58 PM, Scott Graves scott.e.graves@gmail.com wrote:
I've tried that as well and experienced the same delay. I tested more last night and realized local queries are running just as slow. Something else is going on and it seems to be isolated to my server boxes. I notice CPU spikes on my laptop but don't see any usage on the servers when queries are active. Thinking it may be a buffering problem, I wrote my own TCP client to test. No luck.
Do DNS or reverse DNS lookups occur at any time? I had a similar issue with MySQL and had to disable reverse lookup.
On Feb 22, 2013 5:00 AM, "Christian Grün" christian.gruen@gmail.com wrote:
Hi Scott,
different to tell what may be going on here. Maybe it's because the data needs to be transfered to your client over the network? Have you tried queries that don't return any results, or have you wrapped your queries with the "count()" function to reduce the result size?
Best, Christian ___________________________
On Thu, Feb 21, 2013 at 10:51 PM, Scott Graves scott.e.graves@gmail.com wrote:
I'm testing inserts / updates / queries and ran into a puzzling issue. Testing for the existence of a node where the client and server are running on the same box executes in about 4-7ms; however, testing the same query on a remote server executes in a minimum of 1-1.5s.
I've tested on both jre6 and jre7 as well as BaseX installations on 2 different servers. Same issue either way. Although the logs appear to be from 127.0.0.1, I'm actually using an SSH tunnel for testing remotely but there's no real difference.
13:40:51.212 127.0.0.1:32264 admin OK Database 'LibraryDatabase' was opened in 0.84 ms. 1.21 ms 13:40:51.222 127.0.0.1:32264 admin OK QUERY[0] for $d in /db/table[@name='Music Library']/Setting/DataList/Data where $d/@Key='Id' and
$d/@Value='0F5349957FB73A4585FBC7A392D4DEBA20F41667869FE6A8EDB14332E80C255C' return $d 0.12 ms 13:40:51.232 127.0.0.1:32264 admin OK ITER[0] 1.56 ms 13:40:51.247 127.0.0.1:32264 admin REQUEST EXIT 13:40:51.247 127.0.0.1:32264 admin OK 0.32 ms 13:40:52.327 127.0.0.1:32265 admin REQUEST CHECK LibraryDatabase 13:40:52.327 127.0.0.1:32265 admin OK Database 'LibraryDatabase' was opened in 0.8 ms. 1.17 ms
Any help would be appreciated. I've spent only 1 day experimenting so far.
- Scott
BaseX-Talk mailing list BaseX-Talk@mailman.uni-konstanz.de https://mailman.uni-konstanz.de/mailman/listinfo/basex-talk