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
Coruja
Sphere Developer
*****

Posts: 987
Likes Given: 5
Likes Received: 226 in 187 posts
Joined: Jul 2012
Reputation: 7

Dimension Shard
Post: #7
RE: Problem with MySQL
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
(This post was last modified: 01-19-2018 06:07 AM by Coruja.)
01-19-2018 06:06 AM
Find all posts by this user Like Post Quote this message in a reply
[+] 2 users Like Coruja's post
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: 4 Guest(s)

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