[firebird-support] Index Memory Usage

2015-03-16 Thread Ekundayo eday...@yahoo.com [firebird-support]
Hi All, can anyone tell me (or point me in the direction of manuals) how i can calculate the amount of memory used by the indexes of a particular table? I have a table in which I store sha1 hashes (currently about 2 million records) as char(40) and its indexed, I'm wondering if the table would c

Re: [firebird-support] Index Memory Usage

2015-03-17 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
> On Mar 17, 2015, at 1:55 AM, Ekundayo eday...@yahoo.com [firebird-support] > wrote: > > Hi All, can anyone tell me (or point me in the direction of manuals) how i > can calculate the amount of memory used by the indexes of a particular table? Probably not. The challenge is that Firebird

Re: [firebird-support] Index Memory Usage

2015-03-18 Thread Thomas Steinmaurer t...@iblogmanager.com [firebird-support]
> Hi All, can anyone tell me (or point me in the direction of manuals) how > i can calculate the amount of memory used by the indexes of a particular > table? > I have a table in which I store sha1 hashes (currently about 2 million > records) as char(40) and its indexed, I'm wondering if the table

Re: [firebird-support] Index Memory Usage

2015-03-18 Thread Ekundayo eday...@yahoo.com [firebird-support]