Search found 1628 matches
- Sat Aug 26, 2023 7:28 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciated, will compensate
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 # ---------------------------------------------------...
- Sat Aug 26, 2023 3:16 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciated, will compensate
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 ...
- Thu Aug 24, 2023 11:58 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciated, will compensate
To ACDC,
I'm afraid I will not know what to look for. Can you expand on the character in your query?
I'm afraid I will not know what to look for. Can you expand on the character in your query?
- Wed Aug 23, 2023 1:24 pm
- Forum: General discussion and questions about Aware IM
- Topic: More database things I don't know about testing/publishing
- Replies: 3
- Views: 13577
Re: More database things I don't know about testing/publishing
Thank you. I completely understand that. Everything I'm talking about is relevant to the test database only.
- Sun Aug 20, 2023 6:51 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciated, will compensate
Stuck in outbox. Sent to .me
- Sun Aug 20, 2023 4:41 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
- Sun Aug 20, 2023 2:35 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciated, will compensate
It looks like it only supports Linux or RDS servers.
- Sun Aug 20, 2023 2:12 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciated, will compensate
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...
- Sun Aug 20, 2023 12:39 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciated, will compensate
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?
Should it do this? If so, Why?
- Sat Aug 19, 2023 7:57 pm
- Forum: General discussion and questions about Aware IM
- Topic: More database things I don't know about testing/publishing
- Replies: 3
- Views: 13577
More database things I don't know about testing/publishing
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...
- Fri Aug 18, 2023 5:41 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciated, will compensate
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...
- Thu Aug 17, 2023 10:15 pm
- Forum: General discussion and questions about Aware IM
- Topic: Remove Focus from Save button
- Replies: 3
- Views: 15117
Re: Remove Focus from Save button
I've had good results asking ChatGPT for Kendo scripts. You might try that.
- Thu Aug 17, 2023 6:44 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Re: Database latency - all suggestions appreciate, will compensate
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.
- Thu Aug 17, 2023 6:17 pm
- Forum: General discussion and questions about Aware IM
- Topic: Database latency - all suggestions appreciated, will compensate
- Replies: 37
- Views: 126616
Database latency - all suggestions appreciated, will compensate
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...
- Tue Aug 15, 2023 12:06 am
- Forum: General discussion and questions about Aware IM
- Topic: Who can hold my hand to refresh table indexes
- Replies: 2
- Views: 10952
Re: Who can hold my hand to refresh table indexes
Thanks. It appears I can use the Optimize Table command, which in MySQL actually performs an alternate function as the docs explain here: