+ Start a Discussion
yvk431yvk431 

Imprve Search Performance

Hi friends ,

 

 I have implemented a search functionality which searches records more than 100000.

The following are the challenges I am facing , please advice

 

1)Even though the query limit is 10000, If the result number exceeds over 1000 I am getting an error maximum retrieve id limit reached. (think it might be limitation with VFP )

2) because of the large recor numnber , the search performance was pretty slow. I dont know much ways to improve the search , thought of using SOSL but it will return only 200 records at a time.

IS there any thing like indexing for salesforce

 

 

 

 

 

 

Ankit AroraAnkit Arora

First thing now limit of query result is not 10000, its increased to 50000 in spring 11. Second VFP have limit to show only 1000 records, you can overcome this limit by creating a LIST<List<YourObject>>. Also to traverse them you can use pagination.

 

Now if you are quring the records then salesforce will take some time to return the results. To overcome you can introduce solar-lucene indexing.

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page

hattihatti

hi, could you please give more details about solr, how do we host it and how do we use it. Can we use it inside salesforce itself.

Ankit AroraAnkit Arora

I have never used it though, only have theoretical knowledge.

 

Please go through the links
http://lucene.apache.org/
http://lucene.apache.org/solr/

 

Thanks

Ankit Arora

Blog | Facebook | Blog Page

AshesAshes

Hello Ankit,

 

You have mentioned that we can use list<list xyz>> to over come the limit of list. But my question is how can we iterate such nested list in pageBlockTable. 

Please let me know the solution

 

Regards,

Ash