TinTin++ Mud Client The TinTin++ message board

 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 
TinTin++ Mud Client

Indexing map data - performance enhancement or bloat?

 
Post new topic   Reply to topic    The TinTin++ message board Forum Index -> General Discussion
View previous topic :: View next topic  
Author Message
Slysven



Joined: 10 Apr 2011
Posts: 365
Location: As "Jomin al'Bara" in WoTMUD or Wiltshire, UK

PostPosted: Wed Feb 01, 2012 1:28 pm    Post subject: Indexing map data - performance enhancement or bloat? Reply with quote

As mentioned in a previous topic http://tintin.sourceforge.net/board/viewtopic.php?t=1531 I found a way to modify the source code to capture the room numbers that the #MAP LIST command finds in a variable.

I think I have commented in the past that some of the stuff associated with the mapping code does look to have database characteristics. The #MAP LIST command particularly is looking like a query operation! I note though that the search that is done is a straight forward loop through each room vnum in order and check to see if the data for that room matches the given arguments.

Is there a point at which it would be benefical to start using indexes? There are obvious downsides in terms of additional overhead to maintain those indexes and, of course, they will only help if what is indexed is what is being searched for. For me, personally, this would be at least the whole roomname and whole roomdesc - for my case the description is several lines of text.

Does anyone else have thoughts on whether map indexing should go into the feature request area?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    The TinTin++ message board Forum Index -> General Discussion All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Get TinTin++ Mud Client at SourceForge.net. Fast, secure and Free Open Source software downloads Get TinTin++ Mud Client at SourceForge.net. Fast, secure and Free Open Source software downloads
TinTin++ Homepage

Powered by phpBB © 2001, 2002 phpBB Group