SQL mode issues application not responding during insert edit component

[JeffatPrimex]

I could use some ideas on how to troubleshoot ACE 2019/2020 not responding during Insert/Edit Component. The delay is horrible it's like 10-20 seconds and performance monitor shows no CPU usage 

I have tried switching to MS Access and that works fine. We have users with ACE 2018 connecting to the same SQL databases and they have no issues. I have tried different projects and reinstalling ACE with no improvement. 

Any Ideas?

Jeff

[rhesusminus]

Maybe you can turn on debugging, by typing AEONLISPDEBUG. Then, look at the command line while editing a component, to see what part of the process the is slowing it down...

[JeffatPrimex]

See attached. One trace is during a final selection of a part and the other is just changing a part number on the insert edit component form.

look for

<<<<<<<<<<<<<< HANGS UP HERE >>>>>>>>>>>>>>>>>

[rhesusminus]

Yeah. And it's quite obvious that both are database requests.
Do you have a SQL "expert" available ?
I guess it would be possible to trace what the SQL database is doing here... Just to figure out if it's the SQL database that are slow with sending data back, or if it's AcadE that is slow with processing the data it get's back from the SQL server.. It might be a big chunk of data sent back from the server maybe?

[JeffatPrimex · Accepted solution]

I ran into a similar issue today where AutoCad Electical just hangs with not real cpu usage but not responding in task manager so I went to the server to see what was open for the file I had open. I noticed the standards files (3 of them) I had associated with the drawing were open many times repeatedly. I removed the standards files from the drawing and everything worked fine.  

I thought I would pass this along just in case someone is having a similar issue.

Best regards,

Jeff