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: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