10 reasons why I chose MySQL over MSSQL2005 Express

posted by hgarcia(1534) 4 years, 4 months ago 0

The usage of LIMIT has always been a big attraction for me as well.It makes everything so easy in doing paging, no need to define a page size or anything like that, just pass two numbers at the end of the query and you are ready to go. Speed (if you just need read) is as well a very good argument.
LIMIT It's not the same as using TOP 10 That gives you just the first ten results but them you will need the results from 11 to 20 and 21 to 30 etc. There is a way of using top and subqueries to filter the results and achieve a similar result but in that case use pages, it's better.

Reply