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
Warning [2] count(): Parameter must be an array or an object that implements Countable - Line: 786 - File: showthread.php PHP 7.4.33-nmm7 (Linux)
File Line Function
/showthread.php 786 errorHandler->error






Post Reply 
 
Thread Rating:
  • 1 Votes - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Tags vs DB Query?
Author Message
Ultima One
Journeyman
*

Posts: 238
Likes Given: 7
Likes Received: 10 in 6 posts
Joined: Jan 2013
Reputation: 6

Ultima One

Post: #1
Tags vs DB Query?
Hey,

You have all been so helpful so far, now I have a query rather than a help request.

Since there is no way to check how long a snippet script takes to run, I thought I would ask here, and maybe someone in the Sphere Dev team make provide some insight.

I have heard many Rumors that 'Tags cause Lag' - I'm yet to see any solid evidence of it, but just curious. Is it true that the more tags a player has, the higher the chance of him experiencing lag?

So, I was wondering, storing our Tags in a database, would querying our database be quicker than checking a tag? If the time taken is the same (or less), then maybe this could reduce the load on Sphere dramatically?

I would be cautious about storing tags which update more often in the database, as the last thing I want it 100 connections to the database updating and inserting at once.

We are moving to be more reliable on Stored Procedures in a database for our accounts system, 'MyUO' clone and game launcher. And just wondered about Tags.

Any ideas? I could test it, but i doubt i would notice it easily without being able to time how long scripts take in ms.

ULTIMA ONE
The modern, sphere powered Ultima Online server
02-01-2013 02:20 AM
Visit this user's website Find all posts by this user Like Post Quote this message in a reply
Post Reply 


Messages In This Thread
Tags vs DB Query? - Ultima One - 02-01-2013 02:20 AM
RE: Tags vs DB Query? - darksun84 - 02-01-2013, 03:21 AM
RE: Tags vs DB Query? - Ultima One - 02-01-2013, 03:54 AM
RE: Tags vs DB Query? - Wap - 02-01-2013, 03:57 AM
RE: Tags vs DB Query? - Ultima One - 02-01-2013, 05:57 AM
RE: Tags vs DB Query? - darksun84 - 02-01-2013, 06:12 AM
RE: Tags vs DB Query? - Shaklaban - 02-01-2013, 07:36 AM
RE: Tags vs DB Query? - Ultima One - 02-01-2013, 07:44 AM
RE: Tags vs DB Query? - Staff_Stanic - 02-01-2013, 02:00 PM
RE: Tags vs DB Query? - Mordaunt - 02-01-2013, 10:29 PM
RE: Tags vs DB Query? - Ultima One - 02-01-2013, 11:57 PM

Forum Jump:


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