Vishal Narayan wrote: > 3. Performance tuning at DB level and database optimisation: > I've already tried the following : > - primary keys for all tables in use > - indexes on all columns used for joins > Is there anything else I can do towards performance tuning ? Could I use > views to reduce the load on my SQL 2000 DB ?
Delete the candidatemaster.cat_id1, candidatemaster.cat_id2 and candidatemaster.cat_id3 columns and use a separate table to connect the candidatemaster table to the category table. That should do away with the need for outer joins and other unwelcome constructions. Jochem ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
