Discussions
Stay up-to-date with the latest news from NetSuite. You’ll be in the know about how to connect with peers and take your business to new heights at our virtual, in-person, on demand events, and much more.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Advanced search is really slow
I had a basic transaction search which pulled all the purchase orders that are pending billing or partially received (about 200 records). This was running in about 3 or 4 seconds. I needed to do a join to the vendor record to get the vendor company name, so I converted the search to an advanced search. I thought the advanced search would run faster as I only pull the fields that I need, but it takes over 3 minutes to run. Here is the SOAP request:
<soap:Envelope xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance
0