usg40w, wifi, 2 pc, app with postgres sql,too slow

nikko1960

Hi to all, i have an usg40w updated to last firmware, installed with standard configuration, there are two modern pc windows 10 20h2, WIFI connected with static ip, ( no lan cable ), a server and a client, the app is using a postgres sql port for access data from client to server, the queries return data very very slowly, what i have to do to encrease speed ?

If you see data via samba all is working wel.

lalaland

When the app is running SQL query to get data from server, does it have ping latency/jitter during the data return? Assume there is no obvious ping latency/jitter during the postgres data return. it would be slow on application.

nikko1960

thanks lalaland for your answer, how i have solved the problem ? ( workaround ) for now i disconnect USG40w and using the original router, with its firewall, with that router, all works fine, the query ( the total customers are 1500 and the query return them in a couple of seconds ), with USG40w, the same query take more than 45 seconds.

Probably USG40w, try to overcontrol the port  5432 and so is slowing the result query.

But the question is : why USG40w overcontrol the wifi internal connection.

Do i have to teach USG40w to open that port, and where i have to do this instruction

mMontana

Do have wlan and LAN the same subnet?

nikko1960

mMontana, yes but in this situation i need to use only wifi, because we cannot use cables in the office

lalaland

@nikko1960, 
 How about both client and server wireless card link speed and quality? Is the connection quality/speed good?  Moreover, when the postgres return data, how many date would be transmit for TX and RX in general?

mMontana

@nikko1960 you are unsatisfied about network performance.

Therefore, would you share more info about your setup?

Also: can you access to another Access Point as test?