N
N
nigdan2017-01-13 14:29:01
Database design
nigdan, 2017-01-13 14:29:01

SQLite and tables?

Good day to all!
There is a SQLite DB in it I create the table.
Can you please tell me if the approach is correct as shown in the screenshot?
Also of interest are the following:
1) the value of a NULL cell will or will not affect performance;
2) whether optimization becomes more complicated in the presence of NULL;
3) does NULL affect the search for values ​​and their sorting;
In printsepe, I can break this table into 2. and then there will be no holes with NULL, but does that make sense.
a1b28cd420a84f52aae2e7e5c18df20d.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
nigdan, 2017-01-13
@nigdan

Thanks everyone.
Issues resolved independently.
For those who are interested, here is a link that helped solve my questions.
https://habrahabr.ru/post/127327/
The topic can be closed.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question