Bananaprotect [Craftbukkit Plugin]

Linear Mode

Bananaprotect [Craftbukkit Plugin]

bearbin Offline

Offline

Cuberite Developer

Posts: 1,468
Threads: 57
Joined: Jul 2012

Thanks: 12
Given 17 thank(s) in 106 post(s)

#17

10-13-2014, 06:20 AM

SQLite is very fast, so a select in a table of 500k blocks in a table with indexes will be perfectly fine (< 100 ms at least).

Splitting it up would be a bit better, and good index choices really make a difference.

The thing you really have to worry about is database size (CoreProtect a rollback plugin has databases that regularly go up to 5 gigs for small servers).

Find

Reply

« Next Oldest | Next Newest »

Messages In This Thread

Bananaprotect [Craftbukkit Plugin] - by ambushed01 - 10-12-2014, 01:51 AM

RE: Bananaprotect [Craftbukkit Plugin] - by NiLSPACE - 10-12-2014, 01:59 AM

RE: Bananaprotect [Craftbukkit Plugin] - by ambushed01 - 10-12-2014, 02:06 AM

RE: Bananaprotect [Craftbukkit Plugin] - by NiLSPACE - 10-12-2014, 03:12 AM

RE: Bananaprotect [Craftbukkit Plugin] - by ambushed01 - 10-12-2014, 03:15 AM

RE: Bananaprotect [Craftbukkit Plugin] - by NiLSPACE - 10-12-2014, 03:26 AM

RE: Bananaprotect [Craftbukkit Plugin] - by ThuGie - 10-12-2014, 06:12 AM

RE: Bananaprotect [Craftbukkit Plugin] - by xoft - 10-12-2014, 06:19 AM

RE: Bananaprotect [Craftbukkit Plugin] - by xoft - 10-12-2014, 06:20 AM

RE: Bananaprotect [Craftbukkit Plugin] - by ThuGie - 10-12-2014, 06:29 AM

RE: Bananaprotect [Craftbukkit Plugin] - by ambushed01 - 10-12-2014, 12:52 PM

RE: Bananaprotect [Craftbukkit Plugin] - by xoft - 10-12-2014, 07:19 PM

RE: Bananaprotect [Craftbukkit Plugin] - by ambushed01 - 10-13-2014, 02:18 AM

RE: Bananaprotect [Craftbukkit Plugin] - by NiLSPACE - 10-13-2014, 02:26 AM

RE: Bananaprotect [Craftbukkit Plugin] - by ambushed01 - 10-13-2014, 02:33 AM

RE: Bananaprotect [Craftbukkit Plugin] - by xoft - 10-13-2014, 06:02 AM

RE: Bananaprotect [Craftbukkit Plugin] - by bearbin - 10-13-2014, 06:20 AM

RE: Bananaprotect [Craftbukkit Plugin] - by xoft - 10-18-2014, 02:44 AM

RE: Bananaprotect [Craftbukkit Plugin] - by xoft - 10-19-2014, 05:25 AM

View a Printable Version

Users browsing this thread: 2 Guest(s)