Subject | Re: [firebird-support] fb table limit question |
---|---|
Author | Helen Borrie |
Post date | 2006-03-02T00:03:44Z |
At 09:39 AM 2/03/2006, you wrote:
64 Kb, minus a few bytes. Add up the byte count for the declared
size of each column, counting 8 bytes for each BLOB or ARRAY type
column, and adding 2 bytes for each VARCHAR column. Integers,
floats, date, time are 4 bytes; BigInt, double precision, timestamp
are 8; numeric and decimal, 4 (if precision < 10) or 8 otherwise.
(community.ibobjects.com) and the IBO FAQ are both Isapi
dlls. Whether there are any problems specific to Intraweb, I don't
know. The Community site was built with Indy; the FAQ app uses a
regular Delphi web app.
newsgroup interface, as this list is mirrored at
news.atkin.com. Advice about using OE is off-topic here, of course,
but quite a few of us use Xananews, a news client written with Delphi
and Indy. If you're interested, Google for it.
Helen
> hi--There is not a "column count limit". The maximum width of a row is
>
> i am just beginning a conversion from BDE to FB / IBO.
>
> one of my main concerns is the number of fields per record/row in FB.
>
> the BDE is limited to 255 and that is was too low for my app.
>
> i have spent hours looking on the web for a maximum column per row count in
> FB 1.5 and.or 2 and just can't seem to find one.
>
> is there a limit? is it greater then 255?
64 Kb, minus a few bytes. Add up the byte count for the declared
size of each column, counting 8 bytes for each BLOB or ARRAY type
column, and adding 2 bytes for each VARCHAR column. Integers,
floats, date, time are 4 bytes; BigInt, double precision, timestamp
are 8; numeric and decimal, 4 (if precision < 10) or 8 otherwise.
> and one other thing...i also have an ISAPI DLL created with Intraweb. I'mIsapi DLLs work fine with an IBO back-end. The Community site
> assuming that FB / IBO work just fine with IW, correct?
(community.ibobjects.com) and the IBO FAQ are both Isapi
dlls. Whether there are any problems specific to Intraweb, I don't
know. The Community site was built with Indy; the FAQ app uses a
regular Delphi web app.
>(hmmm..i seem to be having a hard time posting this using Outlook ExpressYes. This is an email list, not a newsgroup. You *can* use a
>NewsGroups...so, i emailed it to yahoogroups.com, is that usual?)
newsgroup interface, as this list is mirrored at
news.atkin.com. Advice about using OE is off-topic here, of course,
but quite a few of us use Xananews, a news client written with Delphi
and Indy. If you're interested, Google for it.
Helen