Raised This Month: $ Target: $400
 0% 

MySQL Data Layer


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Backstabnoob
BANNED
Join Date: Feb 2009
Location: Iwotadai Dorm
Old 06-05-2014 , 14:00   Re: MySQL Data Layer
Reply With Quote #3

Eh. The ones I looked at had around 50 thousand lines of terrible code. I don't think I can find anything useful there anyway.


An example using my method:
Players - 30
Opened classes - for example 10
Each class has 4 columns
Each column has a name consisting of 16 characters
Each player has let's say 30 rows in each of the classes (probably won't ever happen, but still)
Maxlen of each string from the trie hashtable would be 128 characters

All in all, that's 30 * 10 * 4 * 16 * 30 * 128 = 73,728,000 cells

A single cell is 4 or 8 bytes, let's go with 4, that's 294,912,000 bytes = 295MB of memory. There must be a better way

Last edited by Backstabnoob; 06-05-2014 at 14:14.
Backstabnoob is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:48.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode