I
I
ivanoffse2014-09-18 15:35:15
SQL
ivanoffse, 2014-09-18 15:35:15

How to organize the structure of the citation?

I am writing my first site, a quote book, and I have reached the most important point - in what form is it more convenient to store quotes on the server and issue them with maximum speed?
Is it suitable to use a SQL table consisting of id, quote, date, upvotes, downvotes, author, or is there an easier and faster way?
Bashorg took for the standard for himself personally.
Do not judge strictly, I just started.

Answer the question

In order to leave comments, you need to log in

2 answer(s)
W
WebSpider, 2014-09-18
@ivanoffse

Or is there an easier and faster way?

Where is it easier then?

T
throughtheether, 2014-09-19
@throughtheether

I myself am new to web programming, but I will express an authoritative opinion from the couch. It is logical to start with a relational database. Then test the site with bots. Understand why doing eleven SQL queries per page is sinful. Then either add a caching layer so that the SQL database is accessed less often, or pick up a suitable NoSQL database. In the first case, in my opinion, "likes" and other frequently updated data will still have to be taken out of the relational database.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question