![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 3 of 3 total |
![]() |
Mon, Feb 14 2022 12:23 PM | Permanent Link |
Krassimira Taralova CPAChem | I'm trying to increase the performance of an application that uses DBISAM SQL Server. The server is accessed by a client application installed on a different PC located in 3 different subnets and the server itself is in a separate 4th subnet. Would I improve the performance of the application if I added three network interfaces on the same server, each in the corresponding subnet, in order to avoid possible delays in the router. With this topology, clients from different floors will use their adjacent server IP address directly with L2 switching?
Do you think there would be a problem with the DBISAM service running on all 4 interfaces at the same time? |
Tue, Feb 15 2022 6:22 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Krassimira
I have no idea about the network because I've never tried anything like that and now I'm retired I'm not likely to but I do have a question. Have you determined that its network speed / capacity that is the cause of any application slowdown or could the bottleneck be somewhere else? Very often performance with SQL is "crippled" by not having the needed indices or by badly written queries. It can also be cause by concurrent queries / transactions setting locks which cause things to have to wait upon completion. Roy Lambert |
Tue, Feb 15 2022 12:21 PM | Permanent Link |
Raul ![]() | On 2/14/2022 12:23 PM, Krassimira Taralova wrote:
> I'm trying to increase the performance of an application that uses DBISAM SQL Server. The server is accessed by a client application installed on a different PC located in 3 different subnets and the server itself is in a separate 4th subnet. Would I improve the performance of the application if I added three network interfaces on the same server, each in the corresponding subnet, in order to avoid possible delays in the router. With this topology, clients from different floors will use their adjacent server IP address directly with L2 switching? Routing is near wire speed these days even for simple routers so i would highly doubt it. It's theoretically possible but performance issues are usually on host or getting data (i.e. very large queries, lack of indexes etc) What's your traceroute timings to the host hosting DBISAM today? Are you seeing a large network latency ? > Do you think there would be a problem with the DBISAM service running on all 4 interfaces at the same time? No - by default it listens on all interfaces already Raul |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |