Single user on a particular module will have an estimation of 4-5 sec data retrieval (stored procedure was used to retrieve data). row count of the table is 600,000+ records (optimized with indexes).
i would seriously look at the locking involved - if your query is taking 5 seconds and then another user is queuing up for that data it would explain it.
can you post the procedure?
MVDBA