Previous Thread
Next Thread
Print Thread
Hop To
#265100 11/10/2021 6:49 PM
Joined: Jan 2004
Posts: 41
J
Jim Offline OP
Newbie
OP Offline
Newbie
J
Joined: Jan 2004
Posts: 41
We had to disable our search feature because it was locking up the forums.
the POST table is type MyISAM which locks the entire table during a search. If we changed the table type to InnoDB, searches will be implemented using row level locking instead of locking the entire table. Is it possible to implement this change?

Thanks
Jim Quinn

Joined: Jun 2006
Posts: 16,116
Likes: 79
UBB.threads Developer
Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,116
Likes: 79
Are you using the FullText search or the UBB.threads Internal search? For larger forums we recommend users use the UBB.threads Internal Search.

As for making changes to your database, that is something that you can opt to do for your personal forums, but it is an unsupported change to your database structure.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jan 2004
Posts: 41
J
Jim Offline OP
Newbie
OP Offline
Newbie
J
Joined: Jan 2004
Posts: 41
We are using UBB.threads Internal.Thanks


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Database Table Conversion
by Jim - 11/10/2021 6:49 PM
Who's Online Now
1 members (Ruben), 90 guests, and 67 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5