V
V
Voll.2017-03-17 20:33:05
MySQL
Voll., 2017-03-17 20:33:05

Storing data about media files in the database. How big will the load be?

I'm planning a database like this:

models
id
name


textures
id
name

media_content
id
mediable_id
mediable_type
type
order
name

media_content_data
id
media_content_id
screen_type
url
extension

media_content has a polymorphic relationship with models and textures.
media_content has a one-to-many relationship with media_content_data.
Question 1, how much will queries and selections load such an architecture (the maximum volume of media_content_data is about 10 thousand fields)?
Question 1, will there be problems when creating such a structure in laravel ORM Elloquent?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
D
Dimonchik, 2017-03-17
@vollthegreat

so what's your choice?
do the job - optimize later: indexes, pagination, replication, shards, nodes, that's all

A
Andrew, 2017-03-23
@iCoderXXI

we store it in the database, cache it in the radish and the main load falls on the radish ...

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question