Previous Thread
Next Thread
Print Thread
Hop To
#265100 11/10/2021 7:49 PM
Joined: Jan 2004
Posts: 41
J
Jim
Offline
Newbie
Newbie
J Offline
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,312
Likes: 118
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,312
Likes: 118
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
Newbie
Newbie
J Offline
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
What happened to UBB Wiki
by Ruben - 07/20/2024 12:07 PM
External Islands
by ECNet - 07/18/2024 12:51 PM
Repeatable issue for file attachments
by Baldeagle - 07/14/2024 11:24 PM
I know this is not the right forum for this
by Baldeagle - 07/11/2024 9:54 PM
topic timestamp does IP lookup of poster?
by Ruben - 07/09/2024 11:36 AM
Who's Online Now
1 members (Ruben), 110 guests, and 371 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240506)