EspoCRM v6 Discussion Thread [v600 | v.6.0.0]

[yuri]

The upgrade command will show a message and won't start if there is any MyIsam table.

[esforim]

Something to do with this?

"Each MyISAM table is stored on disk in two files. The files have names that begin with the table name and have an extension to indicate the file type. The data file has an .MYD (MYData) extension. The index file has an .MYI (MYIndex) extension. The table definition is stored in the MySQL data dictionary."

Reference: https://dev.mysql.com/doc/refman/8.0...ge-engine.html

[esforim]

Here is the Issue for anyone who want to track it: https://github.com/espocrm/espocrm/issues/1775

Question though: How do we tell if we have an MyISAM table or not? Will the EspoCRM Update take care of that conversion?

I assume I don't, and since we using MariaDB so our server is probably on what call Aria.

[yuri]

It's not actual anymore. MyIsam is literally abandoned by Oracle. It's obsolete.

[esforim]

Did a quick check on what that mean. Here is an article from the 2009, it might not be accurate and don't really know much has InnoDB improve for the past 11 years but some fun reading I suppose.

https://www.kavoir.com/2009/09/mysql...-and-cons.html

Few thing that pique my interest is this section:

"MyISAM has full-text search index while InnoDB has not."

That might that mean the search system will not be better than previous version (<5.9.9 which is what we using).

[yuri]

We are likely to drop MyISAM support in 6.0. If we do we will provide instructions how to migrate to InnoDB.

[yuri]

Hi Peter,

There is a likelihood that something won't be compatible. Once we release a beta, you can check.

[yuri]

Actually, I doubt that this can bring a significant performance boost. Database is a bottleneck in applications like CRMs.

[peterberlin]

Hi Yuri

now existing own extensions will also work with the new code of 6.0?
peter

[esforim]

Spotted this update that will greatly benefit performance from the sound of it:
Preloading in PHP 7.4

https://github.com/espocrm/espocrm/issues/1773

It is also a reason for me to move to PHP 7.4 once v6 arrive.

[yuri]

Hi,

The feature list for 6.0 is frozen. Nothing new will be added besides the current feature list available on Github. The main goal for now is a code improvement.

[julobaco]

Hi, I would like to thank you for the great CRM system.

Feature which should be added to the new version v6:
* in case of export results to Excel save the selected 'Field List'. Something like when we can define for the PDF export. Because in case when we need only selected fields to export and are not the same as visible columns we have to manually selected them. Also the order of 'Fields' should be saved.

Thank you.

[item]

Hello,
This is wonderfull improvement : https://github.com/espocrm/espocrm/issues/1767

Please vote

Thanks Yuri

[Oleksii S.]

Sure. Late code better than faulty one,

[yuri]

Hi All,

I've been doing a lot of code refactoring for last weeks, almost all core classes were rewritten to a certain extent. Not sure if I will manage to finish all the work I have planned on schedule. There won't be enough time for testing all this change. So it's likely that we will postpone a release date for a couple weeks.