usg40w, wifi, 2 pc, app with postgres sql,too slow
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.
0
All Replies
-
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.
0 -
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 instruction0
-
Do have wlan and LAN the same subnet?
0 -
mMontana, yes but in this situation i need to use only wifi, because we cannot use cables in the office
0 -
@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?
0 -
@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?0
Categories
- All Categories
- 415 Beta Program
- 2.3K Nebula
- 141 Nebula Ideas
- 94 Nebula Status and Incidents
- 5.5K Security
- 216 USG FLEX H Series
- 262 Security Ideas
- 1.4K Switch
- 71 Switch Ideas
- 1K Wireless
- 39 Wireless Ideas
- 6.3K Consumer Product
- 243 Service & License
- 382 News and Release
- 81 Security Advisories
- 27 Education Center
- 8 [Campaign] Zyxel Network Detective
- 3K FAQ
- 34 Documents
- 34 Nebula Monthly Express
- 83 About Community
- 71 Security Highlight