Grid_1 command - performance?

[dragancesu]

it's a program I made but it's not used much so it still needs to be improved

MySQL doesn't have BOOLEAN/LOGICAL fields, it simulates a TINYINT field

for MEMO it's easy since it has a BLOB type

HMGCASE it's improved because I use it more, MYHMG it's more like an exercise, I don't promise but when I find time I'll fix what needs to be

[AUGE_OHR]

hi,

i wonder that nobody talk about ADO which is also used by SQLRDD

i "think" it have to do that nobody have written a CLASS, like in Fivewin, to handle "Result-Set" with ADO for GRID

---

how are a MYSSQL Server "configure"

i do NOT want to "optimise" Query, i talk about System Variable in "c:\ProgramData\MySQL\MySQL Server x.0\my.ini"
i have read about "MySQL Performance Tuning" and found e.g. these System Variable

innodb_buffer_pool_size
max_connection
query_cache_size
innodb_io_capacity
innodb_log_file_size

but which Value, depend of Hardware e.g. RAM

the Website https://pgtune.leopard.in.ua/ give yuu Answer for PostgreSQL
i´m search for similar for MySQL

query_cache_size (> 16M)
tmp_table_size (> 32M)
max_heap_table_size (> 16M)
table_cache (> 64)
innodb_buffer_pool_size (>= 22M)

https://www.percona.com/blog/mysql-101- ... rformance/

[dragancesu]

i do NOT want to "optimise" Query, i talk about System Variable in "c:\ProgramData\MySQL\MySQL Server x.0\my.ini"
i have read about "MySQL Performance Tuning" and found e.g. these System Variable

Look https://phoenixnap.com/kb/sql-query-optimization-tool

Each database has its own rules on how to optimize a query, therefore general optimization is only the first step, but not enough

[AUGE_OHR]

hi,

thx for Answer

as i say i do NOT talk about Query i talk about configure Server for MySQL
so i talk about \ProgramData\MySQL\MySQL Server x.0\my.ini