3

So I have a list of about 75,000 items. I want to know if I perform a CAML Query that returns a couple of hundred items, is that going to be slow? (slow = 10+ secs, med = 5-9 secs, fast 0-4 secs) Thanks

  • There are many factors which could affect the performance - load on servers, number of users etc. You could do a simple test using a tool like SharePoint CAML Query builder: spcamlqueryhelper.codeplex.com – Russell Jan 7 '13 at 22:40
2

You would never know until you try it, why don't you create a webpart and use performance monitor along the side to judge it.

Anyway Your question should be, I need to get several of hundred of items out of list with 75,000 items, so first thing first, how many options you got to get list items, You can use CAML or Linq as you have to use one of them to query items so you should go for fastest one which is CAML as far as I know but they both have there own advantages.

I was reading a blogpost few months back which stated that fastest query will be where you will be using both CAML and Linq to get your list items and then filter through them.

Some of links you might find helpful are given below,

CAML vs LINQ vs SQL

http://books.google.co.uk/books?id=4lKnn9ZzG1AC&pg=PA214&lpg=PA214&dq=using+caml+and+linq+together&source=bl&ots=LR4vMxoNzw&sig=boCacTuqjug6Rm1mm79gMmeNBYE&hl=en&sa=X&ei=r03rUJqJFMfX0QWW8YCQAw&redir_esc=y#v=onepage&q=using%20caml%20and%20linq%20together&f=false

Hope it helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.