![]() |
|
|
|
#2
|
|||
|
Trips to the database are extremely fast, the bottlenecks are in the queries which is why they pay people the big bucks to optimize them. In the converted relational algebra to get a random saying, all you have is a single projection operation which is probably passed into a mersenne twister (or whatever random generator mysql uses), no sigmas, intersections, unions, cartesian products, or tuple joins; which is where inefficiency comes into play (even moreso with myisam). Pretty much all you're waiting for is the rotational delay of the hard drive and a single block transfer time. If we were really worried about database workload I imagine the project would have switched to something more robust like postgresql ages ago.
| ||
|
Last edited by GODPARTICLE; 05-17-2013 at 01:21 PM..
|
|
||
|
#3
|
||||
|
Quote:
| |||
|
|
||||
|
#4
|
|||
|
Theme song for programming discussion in this thread, Naez is the midget and Rogean is the cop:
http://www.youtube.com/watch?v=C2NW1-_HUbw
__________________
The PvP artist formerly known as Wehrmacht/Tmoney
| ||
|
|
|||
|
#5
|
|||
|
Ya he's a recent grad that still hasn't found a jOb trying to talk textbook vs experience
| ||
|
|
|||
|
#6
|
|||
|
Has everything to do with the discussion. You're making it out like a single read, with a single projection operation, happening in literally the measurement of a nanosecond, is the end of the world.
Also my degree is from UCI, and I have a job making assloads of money for what amounts to reddit all day, all while finishing coursework for my master's to pursue a phd | ||
|
|
|||
|
#7
|
|||
|
All I need to know about you to make assumptions about every pos you make:
Plays eq live Pastes IRC chat into forum Confirmed idiot | ||
|
|
|||
|
#8
|
|||
|
trolls* eqlive
whats your hiccup on irc anyway you always bring it up lol? | ||
|
|
|||
|
#9
|
|||
|
I'm a software engineer not a programmer. I try to read minds, write design specs, and ship it to India
| ||
|
|
|||
|
#10
|
||||
|
Quote:
__________________
| |||
|
|
||||
![]() |
|
|