http://www.newlc.com/topic-1404 Comments for "Database size" en http://www.newlc.com/topic-1404#comment-6464 <div class="smf-content">be aware of one problem with indexes though. if you use transactions when writing to the db and you decide to rollback the transactions, the SDK says the indexes will be in a damaged state and thus unuseable. you will end up with a space overhead that's wasted. you need to repair the db to get it to rebuild the indexes.</div> Wed, 09 Jun 2004 08:50:29 +0200 droll comment 6464 at http://www.newlc.com http://www.newlc.com/topic-1404#comment-6463 <div class="smf-content">I hope the Compact function helped you i just want to explain to you the concept of indexes so that you are in the picture. THe index is a system designed in the databse to make finding records much more faster than without one. But this as usually comes at and expense which is the size. It also matter on what column you put it on. If you put it on the char(128) it is going to be much greater than if you werer to put it on the TUint columns so you will have to make the Ever lasting question Speed or Size?</div> Wed, 28 Jan 2004 16:12:28 +0100 Blackangel comment 6463 at http://www.newlc.com http://www.newlc.com/topic-1404#comment-6462 <div class="smf-content">Hi<br /><br />After the database operations u have to use RDbDatabase::Compact()<br /><br />Helped u ?<br /><br />MeenuJ</div> Wed, 28 Jan 2004 09:02:54 +0100 meenuj comment 6462 at http://www.newlc.com http://www.newlc.com/topic-1404 <div class="smf-content"></div><p><a href="http://www.newlc.com/topic-1404">read more</a></p> http://www.newlc.com/topic-1404#comments Symbian C++ Tue, 27 Jan 2004 17:23:20 +0100 Tibo 2448 at http://www.newlc.com