Tagged with "databases"

Fun MySQL fact of the day: paginated ranges

If the last few Fun MySQL Facts Of The Day weren't enough to convince you that your actions can have severe consequences in a hefty database of hundreds of millions or hundreds of billions of rows, I'm not sure what else can. But they absolutely can, and when the stakes ... read more

Fun MySQL fact of the day: how many rows?

While trying to make sense the best I could of the code paths responsible for implementing SELECT ... LIMIT, I stumbled across a relic of MySQL. I'll admit, it seemed so strange at the time that I wasted too much time trying to understand what and why it existed ... read more

Fun MySQL fact of the day: OFFSET

On Friday, we discussed a simple fact about LIMIT, and that wasn't just because it was Friday (well, maybe a bit), but because I felt it important to have a refresher on how MySQL and the storage engine interact before we look at OFFSET. ... read more

Fun MySQL fact of the day: LIMIT your expectations

Before we take a close look at OFFSETs next week, we're going to take a quick peek inside MySQL to understand how a simple SELECT ... LIMIT works, and while we're going to consider a simple case, we're also going to fold in some information we've already covered. ... read more
1 2 3 4 5 6 7