Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
S
S
Sergey Petrov2020-06-25 18:46:31
MySQL
Sergey Petrov, 2020-06-25 18:46:31

What is the best way to store a tree in mySQL?

There is a task to store a binary tree (that is, each node has no more than 2 descendants). The tree can grow significantly. Hundreds of thousands of knots, probably millions. The user sees a small piece of the tree at a time, but the problem is that he must see how many children each tree node he sees has.

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
V
Vladimir Korotenko, 2020-06-25
@Curosio

Look for nested set it's universal

Similar questions
A
Anholle2019-09-09 11:37:42
How to set up a filter in the feedback form? 0Reply
R
Roman Gamretsky2014-05-27 17:47:30
How to dynamically replace PartialView in one page? 4Reply
A
Alexander Pankov2016-07-11 11:23:40
Where do you get the fluctuations in the price of gold and silver for (for example) a month? 3Reply
7
7a-6662022-02-05 17:26:31
How to get to the runserver that was launched inside the container from the browser? 2Reply
I
IvanN7772018-07-05 08:18:28
What to choose in PHP for working with multiple ORM databases (allocation of common data to a separate database)? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question