Questions

First, these questions I'm sure must have been asked, so if they seem too
basic, is this NG included in fastsearch and what is the qualifier to
search?

I've been playing with FF (sourceforge) a little (I definitely mean a
little). I really like the idea of an embedded c/s database. I'm wondering
about the stability and robustness of the product compared to using
something like Firebird or IB6 OE (which I am using now). Can someone offer
opinions about the comparison or point to link of discussion already taken
place? Also, what is the VARCHAR equivalent in FF/NXDB?

Thanks a bunch,

Lee

We don't yet support variable record size, so VARCHAR is not yet supported,
but CHAR is.

The stability and robustness question is perhaps best answered by having a
look at some testimonals here?

--


Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com


"Lee" <lee_jenkins@datatrakposNOSPAM.com> wrote in message
news:3f7814e1$1@wic040d....
>
> First, these questions I'm sure must have been asked, so if they seem too
> basic, is this NG included in fastsearch and what is the qualifier to
> search?
>
> I've been playing with FF (sourceforge) a little (I definitely mean a
> little). I really like the idea of an embedded c/s database. I'm
wondering
> about the stability and robustness of the product compared to using
> something like Firebird or IB6 OE (which I am using now). Can someone
offer
> opinions about the comparison or point to link of discussion already taken
> place? Also, what is the VARCHAR equivalent in FF/NXDB?
>
> Thanks a bunch,
>
> Lee
>
>

Are the CHAR fields padded when sent over the wire to the client as IB < 6.0
is?

Thanks for the response,

Lee

If you are asking about the space used, then as default yes, the full
recordbuffer is sent even if the string is length 0. The transports have
compression you can turn on to minimize this.

--


Eivind Bakkestuen [NDD]
Please, no email unless requested.
Search Borland and third-party newsgroups here: www.tamaracka.com


"Lee" <lee_jenkins@datatrakposNOSPAM.com> wrote in message
news:3f78729d$1@wic040d....
>
> Are the CHAR fields padded when sent over the wire to the client as IB <
6.0
> is?
>
> Thanks for the response,
>
> Lee
>
>

Thanks Ervind,

That is nice to know. I wonder how much the compression effections response
time. Probably not much based on some of the posts I've seen here so far.

Lee

> That is nice to know. I wonder how much the compression effections response
> time. Probably not much based on some of the posts I've seen here so far.

depends which compression. rle is VERY *fast* and constant for buffersizes. ZIP
compression depends on compression type. 1 (fastest) is fairly fast but 9 (max
compression) adds quite some overhead.
two or three numbers that we got under optimal compression environment
(iterated through a highly compressible 65k record table):
rle compression, 512kBytes RecordBufferSize: on a 100mbit network the transfer
is about 10% slower. on a 56k line the transfer is about 8 times faster.
zip max compression, 512kBytes RecordBufferSize: on a 100mbit network the
transfer is about 100% slower. on a 56k line the transfer is about 53(!) times
faster.

conclusion: the use of compression and buffersize is very dependent on network
speed and application environment. since every client can have its own
compression setting and the server responds with the same compression applied,
you should make this setting a config option in the clients. Also keep in mind
that you can switch compression on and off at ANY time.

There's a more detailed description of this in the developers manual in the
donwloadable manual.

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm

the newsgroups are archived at tamaracka. just use "^nexusdb search words here"
to find stuff. you have to include the ^

--

Hannes Danzl [NexusDB Developer]
Newsgroup archive at http://www.tamaracka.com/search.htm



"Lee" <lee_jenkins@datatrakposNOSPAM.com> wrote in message
news:3f7814e1$1@wic040d....
>
> First, these questions I'm sure must have been asked, so if they seem too
> basic, is this NG included in fastsearch and what is the qualifier to
> search?
>
> I've been playing with FF (sourceforge) a little (I definitely mean a
> little). I really like the idea of an embedded c/s database. I'm wondering
> about the stability and robustness of the product compared to using
> something like Firebird or IB6 OE (which I am using now). Can someone offer
> opinions about the comparison or point to link of discussion already taken
> place? Also, what is the VARCHAR equivalent in FF/NXDB?
>
> Thanks a bunch,
>
> Lee
>
>

Excellent Info, Hannes.

Thank you, I will look at the manual.

Lee

> Excellent Info, Hannes.

Good question too. I learnt something.

Hey, what are you doing following me around from newsgroup to newsgroup?
I can't have you using all the same cutting edge tools as me, too much
competition!! <g>

Lauchlan M

LOL, hey Lauchlan! My kbmMW brother!

Lee

"Lauchlan M" <LMackinnon@Hotmail.com> wrote in message
news:3f79134e$1@wic040d....
> > Excellent Info, Hannes.
>
> Good question too. I learnt something.
>
> Hey, what are you doing following me around from newsgroup to newsgroup?
> I can't have you using all the same cutting edge tools as me, too much
> competition!! <g>
>
> Lauchlan M
>
>