A Little Bit of Self-Advertisement

Sharepointalist recently released a new product – List Booster. It’s a new generation SharePoint add-in, created using JavaScript and CSS only – no server-side code – works for both SharePoint Online (Office 365) and SharePoint 2013. List Booster enhances out of the box SharePoint user experience enabling user to do the following, when working with lists and document libraries:
  • resize columns (including auto-size by double click);
  • change of font styles, text alignment, color and background for columns and headers;
  • real paging (showing total amount of pages and clicking on the page number same way as in Google), visible both on top and bottom of the list;
  • table styles color schemes – same as you have in Microsoft Excel or Word;
  • it all works both in regular view and in quick edit mode.
All those features are very intuitive and easy to use by the end users. Helps a lot with the user adoption within organization and increases performance when working with large lists and document libraries.

You can check out short video about the product at http://www.spbooster.com

Performace of querying items in lists and libraries

Some time ago I was working on project where I needed to query items from several lists and document libraries (each list and library contained 200+ items). I needed to display Title and Url fields from lists and file name and file url from document libraries.
My first code worked too long and I've started to think about increasing the performance of queries.
And here are the things that helped me to increase speed in several times:

  1. Use <ViewFields> inside query instead of Include(...) inside ClientContext.Load()
  2. Use FileRef and FileLeafRef fields instead of File field (which is an object with several properties in it).

That's all. These two changes helped me a lot. And the customer is happy about the performance they have.
Have fun!