Click here to Skip to main content
15,897,891 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Sous Vide everything Pin
OriginalGriff14-Sep-19 10:02
mveOriginalGriff14-Sep-19 10:02 
GeneralRe: Sous Vide everything Pin
Jörgen Andersson14-Sep-19 10:06
professionalJörgen Andersson14-Sep-19 10:06 
GeneralRe: Sous Vide everything Pin
OriginalGriff14-Sep-19 10:25
mveOriginalGriff14-Sep-19 10:25 
GeneralRe: Sous Vide everything Pin
Jörgen Andersson14-Sep-19 10:36
professionalJörgen Andersson14-Sep-19 10:36 
GeneralRe: Sous Vide everything Pin
OriginalGriff14-Sep-19 11:44
mveOriginalGriff14-Sep-19 11:44 
GeneralRe: Sous Vide everything Pin
Munchies_Matt14-Sep-19 22:41
Munchies_Matt14-Sep-19 22:41 
GeneralRe: Sous Vide everything Pin
Jörgen Andersson15-Sep-19 4:24
professionalJörgen Andersson15-Sep-19 4:24 
Rant*sigh* database code is a pain Pin
honey the codewitch14-Sep-19 8:14
mvahoney the codewitch14-Sep-19 8:14 
So I ended up refactoring and adapting an old microsoft codeplex project for doing an in memory B+ tree, because it was already tested and was released under MPL which is nearly the same license as MIT.

win.

And it's all exposed using a happy dictionary interface.

However, I'm looking to do an ISAM file backed B+ tree.

Well, the problem with that is the records have to be fixed length.

It's a limitation the in memory BPlusTree doesn't share (but honestly should, not for consistency, but for performance although with the GC it doesn't really matter)

fixed length means fixed length strings or *some* mechanism for embedding blob style pointers to fields. (Which also makes them non-searchable through the primary query mechanism - you have to use secondary queries and you can't have these as part of your keys). People familiar with RDBMS systems know these restrictions well.

Also, the trouble with that is I don't know quite how to store those fields.

Currently, the file would be laid out in blocks of fixed lengths. If I start storing blob fields in it, then i lose the fixed block layout and perf that comes with it.

I was thinking of laying out the file in fixed length blocks but having the blobs span multiple blocks. That means a bit of wasted space, but not a huge deal.

It does complicate things though because then i need an additional linked list in the file to find the blob fields quickly by reference - possibly another index.

This is the house that jack built. It has turned into a castle.

Rube Goldberg smirks in my general direction.

*headdesk*
When I was growin' up, I was the smartest kid I knew. Maybe that was just because I didn't know that many kids. All I know is now I feel the opposite.

GeneralRe: *sigh* database code is a pain Pin
Jörgen Andersson14-Sep-19 8:57
professionalJörgen Andersson14-Sep-19 8:57 
GeneralRe: *sigh* database code is a pain Pin
honey the codewitch14-Sep-19 11:43
mvahoney the codewitch14-Sep-19 11:43 
GeneralRe: *sigh* database code is a pain Pin
Sander Rossel14-Sep-19 8:59
professionalSander Rossel14-Sep-19 8:59 
GeneralRe: *sigh* database code is a pain Pin
honey the codewitch14-Sep-19 11:44
mvahoney the codewitch14-Sep-19 11:44 
GeneralI had a flat battery today Pin
lopatir14-Sep-19 5:47
lopatir14-Sep-19 5:47 
GeneralRe: I had a flat battery today Pin
Sander Rossel14-Sep-19 5:53
professionalSander Rossel14-Sep-19 5:53 
GeneralRe: I had a flat battery today Pin
OriginalGriff14-Sep-19 5:56
mveOriginalGriff14-Sep-19 5:56 
GeneralRe: I had a flat battery today Pin
Ravi Bhavnani14-Sep-19 6:33
professionalRavi Bhavnani14-Sep-19 6:33 
GeneralRe: I had a flat battery today Pin
honey the codewitch14-Sep-19 7:30
mvahoney the codewitch14-Sep-19 7:30 
GeneralRe: I had a flat battery today Pin
Nelek14-Sep-19 10:45
protectorNelek14-Sep-19 10:45 
GeneralRe: I had a flat battery today Pin
DRHuff14-Sep-19 15:09
DRHuff14-Sep-19 15:09 
GeneralI had a low tire today... Pin
DRHuff14-Sep-19 5:30
DRHuff14-Sep-19 5:30 
GeneralRe: I had a low tire today... Pin
Sander Rossel14-Sep-19 5:46
professionalSander Rossel14-Sep-19 5:46 
GeneralRe: I had a low tire today... Pin
honey the codewitch14-Sep-19 7:31
mvahoney the codewitch14-Sep-19 7:31 
JokeI have this suspicion PinPopular
Nand3214-Sep-19 4:34
Nand3214-Sep-19 4:34 
GeneralRe: I have this suspicion Pin
honey the codewitch14-Sep-19 4:56
mvahoney the codewitch14-Sep-19 4:56 
GeneralRe: I have this suspicion Pin
Sander Rossel14-Sep-19 5:14
professionalSander Rossel14-Sep-19 5:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Straw Poll

Were you affected by the geomagnetic storms this past weekend?
Communication disruptions, electrified pipes, random unexplained blue-screens in Windows - the list of effects is terrifying.
  Results   316 votes