Seen SuiteQL performance degradation after move to...
# performances
Stuart Anderton
10/26/2023, 4:59 PMSeen SuiteQL performance degradation after move to 2023.2. Raised ticket, but anyone else?
j
jen
10/26/2023, 5:10 PMNot so far, but it’s not fast at the best of times.
s
suitedev
10/26/2023, 9:22 PMWe had some really strange issues with queries that worked in 2023.1 and failed in 2023.2.
s
Stuart Anderton
10/26/2023, 9:35 PMTime outs?
s
suitedev
10/26/2023, 9:39 PMNo, it was failed queries
suitedev
10/26/2023, 9:40 PMRuns in 2023.1, fails in 2023.2.
I would agree that performance degraded after the 2023.2 upgrade.
s
Stuart Anderton
10/26/2023, 9:47 PMI've got queries which error out, I can make them run by changing the criteria so they process less data. So the code is fine, it's just hitting an execution limit somewhere, when it didn't before.
Stuart Anderton
10/26/2023, 9:48 PMIt comes up as a search error, not a time out, thiugh it clearly is.
s
suitedev
10/27/2023, 3:33 AMYES, that was the same issue I had..
I was ordering by two columns and it failed, where one column succeeded… Then, when they deployed a fix to my account, the results took 3x longer than usual to return.
j
jen
10/27/2023, 3:27 PMDo you have a defect number? or at least a ticket number? I have a scheduled script that runs the exact same SQL every half hour, it’s failing a couple times daily.
jen
10/27/2023, 3:27 PMthis started happening immediately following our 2023.2 upgrade
jen
10/27/2023, 3:29 PMIt’s logging as SSS_SEARCH_ERROR_OCCURRED Search error occurred: Invalid or unsupported search
d
David Hayden
10/27/2023, 3:30 PMThere was a change that forces usage of formula (HTML) and limits search formulas.
s
Stuart Anderton
10/27/2023, 3:32 PMDo you have documentation of the "limits search formula" bit?
d
David Hayden
10/27/2023, 3:33 PMI'm checking for it now
s
Stuart Anderton
10/27/2023, 3:33 PM@jen Defect 742318
j
jen
10/27/2023, 3:33 PMAwesome, thanks
jen
10/27/2023, 3:34 PMSee page 22
jen
10/27/2023, 3:36 PMIf you’re logged in as Administrator, you should see a link to search for searches that have HTML in
Formula (Text)<br/>d
David Hayden
10/27/2023, 3:37 PMEnd of Support for HTML Code in Saved Search Formula (Text) Fields
To improve the security of saved searches in your account, searches with Formula (Text) fields that contain HTML code now display results as plain text only. To prevent issues with your searches, replace your existing Formula (Text) fields with the new Formula (HTML) field. Access to this new field is based on the Create HTML Formulas in Search permission. For more information about the new Formula (HTML) field and permission, see the help topic Evaluating Code in Saved Searches Using Formula (HTML) Fields.
s
Stuart Anderton
10/27/2023, 3:39 PMThanks but that's not relevant to my issue, which is a SuiteQL query timeout.
j
jen
10/27/2023, 3:43 PMyeah I was wondering…
jen
10/27/2023, 3:43 PMlol
s
Stuart Anderton
10/31/2023, 9:57 AMThis is now fixed for me - NS added some more indexes to the database.
j
jen
10/31/2023, 3:40 PMWe have a scheduled query still intermittently failing….it’s bad news for us, we’re non-compliant without it running reliably
s
suitedev
10/31/2023, 10:22 PMFile a defect with NS @jen They were pretty quick to resolve mine once I convinced them it was important.
j
jen
10/31/2023, 10:55 PMwait….so they resolved yours?
jen
10/31/2023, 10:55 PMyou’d think it would fix it for everyone
jen
10/31/2023, 10:56 PMThey’ve only filed ours as U4 even though we are literally non-compliant now and subject to fines … which I told them
s
suitedev
11/01/2023, 5:33 AMYep, I pushed for it to get to a U3 and it was resolved in 48 hours.
j
jen
11/01/2023, 2:16 PMWould you be willing to share your defect number @suitedev?
s
suitedev
11/01/2023, 2:37 PM@jen 741017
j
jen
11/01/2023, 2:37 PMThank you so much!
👍 1
s
Stuart Anderton
11/01/2023, 5:01 PM@jen I suspect they are looking at the failing SQL and creating indexes on the joins, so it will be different for everyone.
j
jen
11/02/2023, 4:25 PMOurs seems to be sorted now
👍 1
6 Views