RDP connection to App Center

[barrymavin]

haha..
Ok, but 29 seconds.. it's too much... or not?

In this way, also Autosuggestion need to work with the full table.. and when I take focus to the formfield.. it take 29 seconds to read the data from the server..

I have no idea what you are doing...

Are you assigning the autosuggestion SQL SELECT in a delegate or declaring it in the field attributes?

[barrymavin]

You can try all this in the console ODBC tab. As I mentioned previously.

Let me repeat...

Slow network response is typically DNS related.

Reading all records into a combo box is bad design. It’s not just a case of what you want to achieve it’s a matter of designing a solution that is practical and will perform.

[phabio]

Barry.. I use only the Lianja feature.. If I can't use FormField with autosuggestion.. what can I do?

[phabio]

I have no idea what you are doing...

Are you assigning the autosuggestion SQL SELECT in a delegate or declaring it in the field attributes?

I've assign the autosuggestion in the field attribute.

[phabio]

But I don't interact with autosuggestion..

the best way, it's interact on the "keypress" and filter the query, but I think it's not possible..

[barrymavin]

Barry.. I use only the Lianja feature.. If I can't use FormField with autosuggestion.. what can I do?

First of all go read my responses again and follow my advice. Reading all records into a combo box is not going to work and will not scale. You need to rethink your UI design. If you want to present all records and let a user search through them perhaps you should be using a pagination grid section which gets filtered as the user types and requeries the remote table with a suitable WHERE clause.

[barrymavin]

Same response.

First of all go read my responses again and follow my advice. Reading all records into a combo box is not going to work and will not scale. You need to rethink your UI design. If you want to present all records and let a user search through them perhaps you should be using a pagination grid section which gets filtered as the user types and requeries the remote table with a suitable WHERE clause.

[phabio]

I've already written a script to browse the table..


the user write a part of "code" and press "tab" or "enter"..
and I open a browse with the filterd query.

but if I could add Autosuggestion.. I would be very happy.. :-)

have someone some "suggestion"?


thanks
Fabio

[josipradnik]

HI Fabio and Barry,

I am learning about networking from your conversation.
Fabio, can you show me the content of the file "hosts" from your VM /server (in the folder C:\Windows\System32\drivers\etc) ?
And the same file from your client machine (NB), please.

Josip

[phabio]

Hi Josip
from my NB:
192.168.1.4 LianjaServer

On the VM I don't have setting on the Hosts file.

the problem was on the registry LAN settings, caused from a old VPN software.