Quote:
Originally Posted by Paul&John
I have a few cam sites using the API for each request so they use no database at all. Can such sites be theoretically faster then using a site + local sql database? Or only in cases when my server is really shitty slow or gets a ton of request and can't handle them properly?
One of my best performing site in search engines gets data from the API alone, so no local caching etc.
|
My guess is that it would definitely be possible for a site just using the api to be as fast or faster than a site pulling the whole thing into the database.
First of all there are efficient ways to do things and inefficient ways. If someone has coded the api call and parse propely and is doing pagination then that could be a very fast site. However if they are doing just the api and trying to present all the cams all at once then it will probably be a slow load.
On the server side solution, the database has to be designed properly and the sql calls need to be coded properly. Just because something is in a database does not mean it is fast or efficient.
There is a lot of shitty code out there, I know because I have written some of it.
.