Apr 19, 1999, 3:20 PM
Administrator (9387 posts)
Apr 19, 1999, 3:20 PM
Post #6 of 12
Views: 4115
Those SQL calls don't mean much. Links is a lot more then just a series of data access calls. Your viewing links call doesn't take into account spanning pages, sorting links, new/cool first, etc. Also, I don't use CF, but your random looks wrong, the Maximum Id doesn't neccessarily represent the total number of links in the database, and is also probably really inefficent. You want:
SELECT COUNT(*) FROM Links
which is usually known in the table defintion.
Sure, all of that could be moved to cold fusion, but you also need to move the page generation, validation, link checking, category management, public add/modify/search (searching is quite difficult unless you limit your descriptions to 255 characters), templates, etc.
Also, one of Links strongest features is it's customizability. You can easily add/remove fields to the database. Achieving this in SQL is quite difficult.
It's really not as easy as you portray it.
Cheers,
Alex