The following warnings occurred:
Warning [2] Use of undefined constant SAPI_NAME - assumed 'SAPI_NAME' (this will throw an Error in a future version of PHP) - Line: 3388 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3388 errorHandler->error
/showthread.php 116 build_archive_link
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/inc/functions.php 3324 build_forum_breadcrumb
/showthread.php 195 build_forum_breadcrumb
Warning [2] Use of undefined constant IN_ARCHIVE - assumed 'IN_ARCHIVE' (this will throw an Error in a future version of PHP) - Line: 3331 - File: inc/functions.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/inc/functions.php 3331 errorHandler->error
/showthread.php 195 build_forum_breadcrumb




SphereCommunity / Sphere 0.56d / General Help v / Problem with MySQL


Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Problem with MySQL
Author Message
DartHVirS
Apprentice
*

Posts: 21
Likes Given: 1
Likes Received: 1 in 1 posts
Joined: Mar 2010
Reputation: 0



Post: #8
RE: Problem with MySQL
(01-19-2018 06:06 AM)Coruja Wrote:  try using latest sphere build, I optimized the entire MySQL engine and now DB.QUERY function can handle "SELECT ..." commands with up to 64 columns

PS: and also don't forget to use "LIMIT 1" on SELECT or UPDATE commands, this will avoid SQL server to waste performance looping through all rows of the table even when the wanted row is already found

thank you!!
01-19-2018 07:49 AM
Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Messages In This Thread
Problem with MySQL - DartHVirS - 01-13-2018, 03:11 AM
RE: Problem with MySQL - darksun84 - 01-13-2018, 03:25 AM
RE: Problem with MySQL - DartHVirS - 01-13-2018, 03:52 AM
RE: Problem with MySQL - DartHVirS - 01-13-2018, 02:16 PM
RE: Problem with MySQL - Coruja - 01-15-2018, 06:02 PM
RE: Problem with MySQL - Kanibal - 01-16-2018, 06:46 AM
RE: Problem with MySQL - Coruja - 01-19-2018, 06:06 AM
RE: Problem with MySQL - DartHVirS - 01-19-2018 07:49 AM
RE: Problem with MySQL - invernizzi - 01-20-2018, 10:15 PM

Forum Jump:


User(s) browsing this thread: 2 Guest(s)

Contact Us | SphereCommunity | Return to Top | Return to Content | Mobile Version | RSS Syndication