Home -> Usenet -> comp.databases.theory -> newbie question

newbie question

From: Olivier Deme <odeme_at_titanic.rtxirl.ie>
Date: 2000/06/06
Message-ID: <Pine.LNX.4.10.10006060947340.967-100000_at_titanic.rtxirl.ie>#1/1 






Hello,



I am a complete beginner with database programming and I need some help.



I have written a program that parses source code and extracts symbols in a
database.



En entry consists of:






I am using the Berkeley DB freeware for managing my database.



The problem is that, for a big input (source code > 10000 lines), my database
becomes very very big. Addition of entries to the database becomes very
quickly slow because of the database size.



I believe the problem comes from the way I am storing the entries in the
database.



In the same database, I probably have thousands of entries with the same key
but with slight variations of data.



I believe I should use cross reference tables in order to decrease my database
size.


Unfortunately, I don't know how to proceed.



Any help would be much appreciated.


Olivier.





Olivier Deme                              
Software Engineer                               ~   
AIRTEL-ATN                                    .   . 
Phone:          +353-1-284 2821              /  v  \
                +353-1-214 7910 (Direct)    /(     )\    
Email:          olivier.deme_at_airtel-atn.com   ^^-^^
Web:            www.airtel-atn.com
-------------------------------------------------------------------------


Received on Tue Jun 06 2000 - 00:00:00 CEST












Original text of this message