Interview Question in Data Mining


 

Interview Question :: Will there be a performance variance for SQL queries on different Operating Systems


I am facing performance issues in my project at client side, which are not found at my side. The only difference is in the Operating System. Client uses Solaris where as mine is windows.

The project uses various database operations(Inserts, Updates and deletes) on huge amount of data. Please tell me will there be a performance variance for the SQL queries on different Operating systems.
Answers to "Will there be a performance variance for SQL queries on different Operating Systems"
RE: Will there be a performance variance for SQL queries on different Operating Systems?

Usually the operating system isn't the problem but rather the performance of the queries that you are doing. If your queries aren't efficient, you could be putting the server through much more work than is needed ( this is more pronounced when you have lots of data). You should lookup database tuning for the particular database that you are using. It looks like your windows application is connecting to a database on a solaris machine. If the connector is written properly and there is no issues with the network, then try to repair the database tables on the solaris machine to see if it's corrupted and properly indexed before trying to optimize the queries.
 
Vote for this answer ::  
Update Alert Setting