Have you looked at your MySql error logs for clues
Also, inspect the my.ini file for limitations that may exist due to table growth.
What about some odd character in the data thats messing with the query, I had this once before on slow queries
Search found 1148 matches
- Sun Aug 20, 2023 6:02 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 169946
- Sun Aug 20, 2023 4:29 am
- Forum: General discussion and questions about Aware IM
- Topic: Aria AI knows about AIM
- Replies: 5
- Views: 15967
Re: Aria AI knows about AIM
Bringing AI tools into the configurator would be a game changer. To ensure its effectiveness, the AI system would need to undergo training based on the inner workings of AwareIM, rather than relying solely on publicly available information. I hope Vlad recognizes the immense potential presented here...
- Sun Aug 20, 2023 2:49 am
- Forum: General discussion and questions about Aware IM
- Topic: Aria AI knows about AIM
- Replies: 5
- Views: 15967
Re: Aria AI knows about AIM
It should be able to write an Advanced script
- Sun Aug 20, 2023 2:37 am
- Forum: General discussion and questions about Aware IM
- Topic: Aria AI knows about AIM
- Replies: 5
- Views: 15967
Re: Aria AI knows about AIM
a better prompt would be : Build me an AwareIM App too manage a Mechanics business and return the BSV configuration fileDescribe how to build an AwareIM app to manage a mechanics business
...maybe a job for GPT-Engineer
- Fri Aug 18, 2023 7:18 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 169946
Re: Database latency - all suggestions appreciated, will compensate
As I said, in July several table indexes pointing to PHS_RID just went missing and slowed down a bunch of stuff. In light of this, I would re-deploy. Unless of course you have time to dig deeper. I would move a copy of the app to another machine with all the data and simulate the problem. Start a p...
- Fri Aug 18, 2023 5:26 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 169946
Re: Database latency - all suggestions appreciated, will compensate
1, When you run the slow query, have you monitored the memory usage. Does it spike or gradually grow. How much headroom is available afterwards. When the system is idle, reboot the server, take a memory usage reading and then run the query to establish its impact 2. In review, many indexes were simp...
- Fri Jul 28, 2023 10:28 pm
- Forum: General discussion and questions about Aware IM
- Topic: Several business spaces with a single database
- Replies: 17
- Views: 51091
Re: Several business spaces with a single database
Off topic Mark, did you manually create all the foreign key relationships to your DB? Or do you have some magic way to create those to then map your ERD? Having foreign keys embedded in the DB makes it more compatible to external BI tools and reporting apps. Would this not be a great feature to hav...
- Tue Jul 25, 2023 9:35 pm
- Forum: General discussion and questions about Aware IM
- Topic: Config Tool Windows aren't sized correctly
- Replies: 7
- Views: 10516
Re: Config Tool Windows aren't sized correctly
I am sure a way around this problem is to simply increase the default size of the pop-up forms in the Configurator. Why are the pop-up forms that small anyway. We can at least double the size of the width, also some on the height. I find myself always having to stretch the form to see rule details. ...
- Mon Jul 24, 2023 5:53 pm
- Forum: General discussion and questions about Aware IM
- Topic: Config Tool Windows aren't sized correctly
- Replies: 7
- Views: 10516
Re: Config Tool Windows aren't sized correctly
Lots of places for a new user to totally get hung up and frustrated. Totally agree, new users move on There are numerous places where this occurs, the only way sometimes is to change screen res to access the settings. Adjusting the form size ignores the area in the form that needs adjusting. All th...
- Thu Jul 13, 2023 8:49 pm
- Forum: Wish List
- Topic: Rest - Sort Order
- Replies: 0
- Views: 89310
Rest - Sort Order
The Rest service in the service setup lacks a logical sort order, which can be quite frustrating when dealing with multiple services. It becomes difficult to sift through the list without any specific order. It would be greatly appreciated if the list could be sorted alphabetically based on the serv...
- Wed Jul 05, 2023 7:12 pm
- Forum: General discussion and questions about Aware IM
- Topic: REST configuration- Boolean being sent as text in a POST
- Replies: 5
- Views: 6264
Re: REST configuration- Boolean being sent as text in a POST
but I create a JSON_String field/object in the User Table or the new NP in-memory table... building a string to match the endpoint requirements and then I use "Take from context" specifying that table and field that has the JSON. So you are building the json string manually ? If there was a functio...
- Tue Jul 04, 2023 1:55 am
- Forum: General discussion and questions about Aware IM
- Topic: REST configuration- Boolean being sent as text in a POST
- Replies: 5
- Views: 6264
Re: REST configuration- Boolean being sent as text in a POST
I also think I'd never use "Take from context" using the "None" attribute (as you must be doing) because then all fields from that table would be sent to that API and what about extra fields you don't want to send them? Yes, you can exclude some fields in the service, but that might be a huge list ...
- Tue Jul 04, 2023 1:41 am
- Forum: General discussion and questions about Aware IM
- Topic: REST configuration- Boolean being sent as text in a POST
- Replies: 5
- Views: 6264
Re: REST configuration- Boolean being sent as text in a POST
I'm not sure why you say "Take from context" is so powerful. I've used this a lot - but I create a JSON_String field/object in the User Table or the new NP in-memory table... building a string to match the endpoint requirements and then I use "Take from context" specifying that table and field that...
- Mon Jul 03, 2023 8:26 pm
- Forum: Problem reports
- Topic: Configurator - memory leaks,
- Replies: 14
- Views: 107711
Re: Configurator - memory leaks,
This problem still persistsaware_support wrote: ↑Mon Mar 15, 2021 2:49 am Thanks, this is not a memory leak - just a regular bug
- Mon Jul 03, 2023 6:36 pm
- Forum: Problem reports
- Topic: REST- handling Boolean - Yes/No, 2 issues
- Replies: 1
- Views: 17012
REST- handling Boolean - Yes/No, 2 issues
I am re-listing this post to the problem area,hopefully it will get traction. Summary:(two separate problems) 1. The boolean (YesNo) is being sent as though it were text and resulting in a failed POST attempt. 2. Also the boolean is being sent as a "yes" or "no" , when it should be sent as "true" or...