Click here to Skip to main content
15,922,533 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
On Azure sql server ,I have created CLUSTERED INDEX partition for a table with 7 millions record . Then my website takes more than 10 seconds to load data .But if I don't create CLUSTERED INDEX partition , my website takes nearly 6 seconds to load data. If I use the same database which created CLUSTERED INDEX partition on sql server enterprise and put it on a server located in the LAN, my website takes about 3 seconds to load data .

What I have tried:

Could you tell me any solution for this problem. Thanks
Posted
Updated 27-Mar-19 2:32am
Comments
[no name] 15-Mar-19 1:56am    
I think you have a "scheduling" problem. Unless instead of "load" you mean something else.

1 solution

Are you using any order by clause while displaying data? and it is totally irrelevant to any of the non-clustered index created?
 
Share this answer
 
Comments
CHill60 27-Mar-19 10:06am    
Please use the "Have a question or comment?" link unless you actually have a solution

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