You need to sign in to do that
Don't have an account?
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
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
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.
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
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