Performance Tuning – Good For Developers – Part 2
Scene 2 — Use stored procedure instead of individual queries because
– It reduces the network traffic
– Query plan got created once for same query which could be re-used instead of creating again and again.
– Stored procedure can be invoked by passing different parameters instead of sending newly created query again and again.
Scene 3 – Make sure there are no table scan on large tables.Check the Sybase Wiki @ sybasewiki.com