Aware IM User Forums

Good thoughts but I don't really think it's the query since other queries, and even the general query on this table from the administrator object query is very slow. My.ini: # Other default tuning values # MySQL Server Instance Configuration File # ---------------------------------------------------...

My current thinking is that this is a database issue (MySQL 5.6). When I query the PHS table from the Administrator's VP, I get the same latency. Another table, Candidate, has about the same number of records and displays in about 1 second. There is no reason the PHS table should take any longer. I ...

To ACDC,
I'm afraid I will not know what to look for. Can you expand on the character in your query?

Thank you. I completely understand that. Everything I'm talking about is relevant to the test database only.

Stuck in outbox. Sent to .me

See my PM.

It looks like it only supports Linux or RDS servers.

I believe I have exhausted all possibilities that I can conceive of. To review: 1. This particular query has not changed in ages but has suddenly slowed to about 25 seconds. 2. I have performed all table maintenance functions on the PHS table as well as others i.e., ANALYZE TABLE, OPTIMIZE TABLE, CH...

In testing, I note that this query selects all columns from the table, not just those defined in the query. There are about 150 columns. This seems very inefficient. In total, this is about 6,000 characters. In design, there are about 18 columns selected.
Should it do this? If so, Why?

I began a significant expansion of my application that will instantiate many new business objects. So of course, I made a copy of my test database consistent with the current BSV. After doing much work, I wanted to make a very small change to the previous (CURRENT) BSV. Of course, I made a copy of m...

Good suggestions for sure. The machine has 8GB and memory usage is consistently low and stable. I have monitored machine memory as the query runs and I see no stress. This query is the user's dashboard that displays PHS records where the PHS.ID = the Account.ID and the PHS Investigator.ID = LoggedIn...

I've had good results asking ChatGPT for Kendo scripts. You might try that.

I would be happy to but I have no reason to think it is an Aware IM issue and I imagine he would be inclined to point to the database. It just seems to be a database issue and I think he would think so as well.

Background: My database is MySQL 5.6. My last update was published June 21st and it was the fourth minor update since that last BSV that included database changes, which were minor i.e., add a column. Around mid July, a user said some data was missing, when in fact, it was just taking around 30 seco...

Thanks. It appears I can use the Optimize Table command, which in MySQL actually performs an alternate function as the docs explain here: