Subject RE: [firebird-support] External Table Size
Author jft
Hardy,
To get your ODS version onnect to your database using iSql and type the command:
show database;
HTH,
John
> -------Original Message-------
> From: Hardy Sherwood <HardyS@...>
> Subject: RE: [firebird-support] External Table Size
> Sent: 10 Jul '07 03:46
>
> Dimitry,
>
> I'm using FB server version WI-V2.0.0.12748.
>
> What is a Database ODS version? How do I determine what version I'm
> running?
>
> Thanks,
>
> Hardy
>
> -----Original Message-----
> From: [LINK: mailto:firebird-support%40yahoogroups.com]
> firebird-support@yahoogroups.com
> [mailto:[LINK: mailto:firebird-support%40yahoogroups.com]
> firebird-support@yahoogroups.com] On Behalf Of Dmitry Yemanov
> Sent: Monday, July 09, 2007 9:53 AM
> To: [LINK: mailto:firebird-support%40yahoogroups.com]
> firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] External Table Size
>
> Hardy Sherwood wrote:
>
> >
>
> > As I understand, the limit on external table size is 2gb.
>
> Correct.
>
> > Is there any plan to increase the limit?
>
> Yes. It just has quite low priority.
>
> > If so, I'd appreciate if you'd let me know
>
> > what's the time frame for doing so?
>
> It hasn't been scheduled for any release yet. The v2.1 release has some
>
> improvements in the external tables area, so perhaps it would be the
>
> best version to make the external I/O 64-bit aware, but it's already in
>
> the Beta stage, so I cannot give you any promises, sorry.
>
> > PS: I thought that I should let you know that the alignment rules for
> fields
>
> > in external tables have inconsistencies. For example, I observed a
> bigint
>
> > field being aligned to a 4 byte boundary that was not on an 8 byte
> boundary.
>
> What FB version and database ODS version do you work with? The BIGINT
>
> alignment boundary is 4 bytes for ODS <= 10 and 8 bytes for ODS >= 11.
>
> Dmitry
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit [LINK: http://www.firebirdsql.org] http://www.firebirdsql.org and
> click the Resources item
>
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at [LINK: http://www.ibphoenix.com]
> http://www.ibphoenix.com
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
> [LINK: http://groups.yahoo.com/group/firebird-support/]
> http://groups.yahoo.com/group/firebird-support/
>
> Individual Email | Traditional
>
> [LINK: http://groups.yahoo.com/group/firebird-support/join]
> http://groups.yahoo.com/group/firebird-support/join
>
> (Yahoo! ID required)
>
> mailto:[LINK: mailto:firebird-support-digest%40yahoogroups.com]
> firebird-support-digest@yahoogroups.com
>
> mailto:[LINK: mailto:firebird-support-fullfeatured%40yahoogroups.com]
> firebird-support-fullfeatured@yahoogroups.com
>
> [LINK: mailto:firebird-support-unsubscribe%40yahoogroups.com]
> firebird-support-unsubscribe@yahoogroups.com
>
> [LINK: http://docs.yahoo.com/info/terms/]
> http://docs.yahoo.com/info/terms/
>
> ----------------------------------------------------------
> This message and contents are confidential and intended solely for
> the use of the individual or entity to whom they are addressed. If you
> have received this email in error please notify the system manager.
>
> The original email message has been scanned for computer viruses.
> ----------------------------------------------------------
>
> [Non-text portions of this message have been removed]
>
>