AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] InnoDB and indexes

4 Posts
3 Users
0 Reactions
2,387 Views
Posts: 316
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@1sharonkat)
Reputable Member
Joined: 9 years ago
[#5070]

With regard to:

https://wpforo.com/community/faq/forum-is-slow/#post-11391

My question is why to have 2 standards and not one?

After all, and with time most forums will grow, also feature releases of wpForo may have compatibility issues.

Regardless, for the technically challenged, can the developers add a script to the "Tools" to be executed only once for pre 1.4 installations? My understanding is that new install of 1.4 and up includes the new DB structure.

As for myself, I'm maintaining my sites [blogs and forums] but avoiding touching anything that is "under the hood". I even do not know what is the DB name and password.

Thank you

 

 


3 Replies
Posts: 1593
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@anonymous20)
Noble Member
Joined: 10 years ago

Looking at my tables, i see a mixture of MyISAM and Innodb. From various plugins.

I THINK searchable tables are MyISAM, this is what i understant.

 


Robert
Posts: 10733
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 2 months ago
Posted by: yossik

With regard to:

https://wpforo.com/community/faq/forum-is-slow/#post-11391

My question is why to have 2 standards and not one?

After all, and with time most forums will grow, also feature releases of wpForo may have compatibility issues.

Regardless, for the technically challenged, can the developers add a script to the "Tools" to be executed only once for pre 1.4 installations? My understanding is that new install of 1.4 and up includes the new DB structure.

As for myself, I'm maintaining my sites [blogs and forums] but avoiding touching anything that is "under the hood". I even do not know what is the DB name and password.

Thank you

 

 

All new installations already come with these indexes.  There is only one standard after 1.4.0. This topic created for old installations, because adding this SQL on update process may overload server, these are heavy SQLs. New installation creates indexes with empty table, it's fast and light, but adding indexes in large table may stop plugin Update process, so we suggest it to execute manually until we add some tool in dashboard.


Posts: 316
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@1sharonkat)
Reputable Member
Joined: 9 years ago

so we suggest it to execute manually until we add some tool in dashboard.

Thank you


Share: