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?

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

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