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