Click here to Skip to main content
14,880,336 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi All,

I created view with 4 tables by joining primary key of the all the tables.
when I access the view by select query . it gets very slow to fetch the records.
view has more than 1 Lack records. but if I create a table with View data, while selecting table data it is fetched fastly .

I need to get the data from the view fastly.

How can we do that???


Thanks,
Palraj M.
Posted
Updated 5-Jul-13 3:03am
v2

Using Join may slow down the process and it will leads to low performance.

Try to concentrate on condition where you are joining the table (i.e. 'on' condition)

& select only needed columns

It may work.
   
Don't use * in any query
try to normalize your query.
Remove unnecessary columns from your query.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900