Upcoming changes

[Colgate]

can we get a confirmation on what color said text will be?

[Smedy]

Rumor is orange

[GODPARTICLE]

Originally Posted by Rogean [You must be logged in to view images. Log in or Register.]

And yet we have far more sophisticated tracking on numerous systems such as that in the game, as I'm sure you've seen.

Or have you?

http://www.rogean.com/images/p99sysencsearch.png
http://www.rogean.com/images/p99sysencdetails.png
http://www.rogean.com/images/p99sysnpctrade.png

Point of all this.. Those logging systems don't make a single database call from the zoneserver process.

Database queries are 10 years ago. Get on my level.

So you store them locally in memory for awhile and take a big dump then, you don't avoid the database

[Rogean]

Originally Posted by GODPARTICLE [You must be logged in to view images. Log in or Register.]

So you store them locally in memory for awhile and take a big dump then, you don't avoid the database

Bzzzzt

[Rogean]

Guy thinks hes gods gift to programming flashing his college degree around and still doesn't know shit about efficient coding.

[GODPARTICLE]

So what are you storing in if not a database?

Also I am a performance stickler, a fucking MyISAM read is not a bottleneck rofl

[Rogean]

Originally Posted by GODPARTICLE [You must be logged in to view images. Log in or Register.]

So what are you storing in if not a database?

Also I am a performance stickler, a fucking MyISAM read is not a bottleneck rofl

Anything that locks up the process waiting for a response from a different service, even if it's just an ACK from a database insert, is a bottleneck. What happens if the database query gets lock queued (because that does happen from time to time with 1k users online). There's a reason removing the bulk of on-demand SQL Queries from zoneprocess improved our stability tremendously.

You're thinking strictly from a database model point of view. What you need to consider is everything else that goes on including the code in the zone process itself handling all the database code, the transport code, and then the WAITING it does. You shouldn't have to fucking WAIT for a database to go "Herr ok I inserted it" before resuming code execution on an UPDATE/INSERT. (And yes, you still get the same problem with INSERT DELAYED, although only slightly improved).

[GODPARTICLE]

the database object is a model anyway. you can cache the results in a static variable and reload as necessary in GetRandPVPSaying()

[Gongshow]

[You must be logged in to view images. Log in or Register.]

[letsjoe]

[stone awful game]: (Fecal) ya
[stone awful game]: (Fecal) if rogean would respond
[stone awful game]: (Fecal) like this
[stone awful game]: (Fecal) to issues with the server
[stone awful game]: (Fecal) shit would be great

agreed