Re: [Mantisbt-dev] Question about bug_text

[Glenn H. <thr...@ma...>]

On 11-Apr-06, at 6:18 AM, Colin Pitrat wrote:

> Hello,
>
> I'm currently writing an export script from gnats to mantis, and  
> I'd like to know if there's a possibility for the bug_text last id  
> to be different from the bug last id. If it's not, why is there two  
> different tables ?
>

   You are correct, bug_table.id is usually the same as  
bug_text_table.id. There is a pointer (.bug_text_id) in the former to  
get to the latter. It is possible that they can get out of step since  
both id values are auto-assigned when the row is created.

   This arises, I believe, from storage issues in some databases. It  
is better to store large text or binary objects in their own tables  
because of the way tables are stored and indexed. Texts are stored in  
their own pages, and mixing them with other fields leads to over- 
allocation of memory.

-- 
Glenn Henshaw                     Logical Outcome Ltd.
e: thr...@ma...              w: www.logicaloutcome.ca
Mantis developer and user