Nicolas Reinschmidt - 2015-07-01

Hello, I have a strange performance problem with access to a FlashFiler2 database over Internet. My FlashFiler client application tries to load about 3000 data rows in a single query. In an installation with FlashFiler client and server on the same computer the query takes a few seconds. If the client connects to the database over Internet the query takes about 30 seconds.

The strange thing is this: I have created a web application that sits on the same computer as the FlashFiler server, accesses the database locally and sends the same data as before json-formatted over the wire to a web browser. This only takes a few seconds, altough it results in the same data on the client side as before with the FlashFiler client taking 30 seconds.

Any idea whether it is inefficient to query data with FlashFiler clients over Internet compared to sending json document?