Discussions
- General Development
- Schema Development
- Apex Code Development
- Visualforce Development
- Formulas & Validation Rules
- Security
- Mobile
- Force.com Sites & Site.com
- Chatter Development
- Java Development
- .NET Development
- Perl, PHP, Python & Ruby
- Desktop Integration
- APIs and Integrations
- Visual Workflow
- Apple, Mac and OS X
- VB and Office Development
- AppExchange Directory & Packaging
- Salesforce Labs & Open Source Projects
- Other Salesforce Applications
- Jobs Board
- Force.com Discussion Boards
- :
- Developer Boards for Force.com and Database.com
- :
- General Development
- :
- SOSL slow - Searching objects in salesforce for an...
turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
0
SOSL slow - Searching objects in salesforce for an email address
Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
12-13-2012 09:20 AM
Hi,
I am trying to search all objects in Contacts, Accounts and Leads with a specific email address, rather than querying the Saleforce each time for Contacts , Leads and Accounts for the email address , I used the SOSL query
FIND {email_address} IN Email Fields RETURNING Contact(Id), Lead(Id),Account(Id)
But this query is very slow and takes a while. Is there any way I could improve the speed of this?
Do you think querying Salesforce for 3 times for Contact , Account and Lead is a faster approach, please let me know.
Thanks,
ns
