I made a little test to see which dB is faster. I run /emergeblocks (-1000,-20,-1000)(1000,20,1000)
Leveldb was a little bit slower, but not much. The more interesting fact was that the sqlite DB has 66MB, leveldb only 36MB
Maybe just an interesting FYI
FOSS gamedev and creative worlds
This is a mostly frozen copy of the Minetest forums through 2017. If you know phpBB3 and would like to host any G-rated forum here, you can email: me@minetest.org If the email doesn't work, find out who's taken over Final Minetest from OldCoder and email them to get write access or an admin account.
I should have set this up years ago. But it's no tale of woe.
Whether the temperature is high or low, regardless of cold winds blow,
away we go like Edgar Allan Poe, on now with the show. BTW rhymes are welcome.
Use leveldb instead of sqlite for huge maps
8 posts
• Page 1 of 1
-
burli - Member
- Posts: 1313
- Joined: Fri Apr 10, 2015 13:18
-
Sergey - Member
- Posts: 362
- Joined: Wed Jan 11, 2017 13:28
Re: Use leveldb instead of sqlite for huge maps
Recently I ran /emergeblocks (-5000, -50, -5000) (5000, 150, 5000)
About 5 hours of processing and 4.2 GB of map.sqlite file size.
About 5 hours of processing and 4.2 GB of map.sqlite file size.
-
burli - Member
- Posts: 1313
- Joined: Fri Apr 10, 2015 13:18
Re: Use leveldb instead of sqlite for huge maps
The map only has ~1900 mapblocks from the center to the edge, if I'm not totally wrong.
From center to edge are ~31000 nodes, each mapblock has 16 nodes.
31000/16=1937.5
Or did I miss something and emergeblocks means nodes and not mapblocks?
From center to edge are ~31000 nodes, each mapblock has 16 nodes.
31000/16=1937.5
Or did I miss something and emergeblocks means nodes and not mapblocks?
-
Sergey - Member
- Posts: 362
- Joined: Wed Jan 11, 2017 13:28
Re: Use leveldb instead of sqlite for huge maps
burli wrote:The map only has ~1900 mapblocks from the center to the edge, if I'm not totally wrong.
From center to edge are ~31000 nodes, each mapblock has 16 nodes.
31000/16=1937.5
Or did I miss something and emergeblocks means nodes and not mapblocks?
Not mapblocks. Coordinates. You can type /emergeblocks (-10.5, -5.5, 0) (10.9, 1.5, 20)
From wiki:
Your phone or window isn't wide enough to display the code box. If it's a phone, try rotating it to landscape mode.— Starts loading (or generating, if inexistent) map blocks contained in the area within pos1 and pos2
- Code: Select all
/emergeblocks <pos1> <pos2>
http://wiki.minetest.net/Server_commands
-
burli - Member
- Posts: 1313
- Joined: Fri Apr 10, 2015 13:18
Re: Use leveldb instead of sqlite for huge maps
Sergey wrote:Recently I ran /emergeblocks (-5000, -50, -5000) (5000, 150, 5000)
If I run this I got error messages like "couldn't get block..."
-
Sergey - Member
- Posts: 362
- Joined: Wed Jan 11, 2017 13:28
Re: Use leveldb instead of sqlite for huge maps
burli wrote:Sergey wrote:Recently I ran /emergeblocks (-5000, -50, -5000) (5000, 150, 5000)
If I run this I got error messages like "couldn't get block..."
That's strange. I had no error messages.
Well, to be honest, I had no messages at all, not only error messages but also processing messages. I thought my computer froze, but I look into MT world folder and map.sqlite was growing.
Re: Use leveldb instead of sqlite for huge maps
/emergeblocks takes 2 co-ordinates in node units, it means 'emerge or generate the mapblocks that intersect the volume defined by these node co-ordinates'.
-
Sergey - Member
- Posts: 362
- Joined: Wed Jan 11, 2017 13:28
8 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 112 guests