Is your SQL select statement using "select * from" or are you just selecting the required rows?
Using "select *" can be slower if you are loading a lot of columns that are then not loaded into QlikView.
Try just selecting the rows you need in SQL.
Also depending on the drivers, OLEDB (ADO) connections can be faster than ODBC.
I would also monitor the memory usage and CPU usage both when the server is running normally servicing user requests and when a reload is running. With Publisher on box3, then this server should be handling the reload overhead.
How many cpu cores are on each server and what speed?
How much ram on each server?
How many network cards on each server and what is the speed of the network connection to each server and to the SQL database where you are extracting the data?
Thanks for the response.
I am using "select *" in the query.But, the same query is running fine on other boxes 1 & 2.
I am only facing performance issue in box 3.
RAM on box 3 is 16 GB,
RAM on box 1 and box 2 is 64 GB.
Box 1,2, and 3 are in production environment.
In dev environment, Devbox 1 has just 8 GB RAM but the performance on the same database is fine.
1) Do you think that 16 GB RAM is making the performance slow? But, it works fine on 8 GB RAM in dev.
2) Is there any restriction that Qlikview Desktop/Developer cannot be installed in the same box as Qlikview Publisher? Will it affect performance in any way?