#1  
Old 29th September 2003, 11:34 PM
Lee
 
Posts: n/a
Default 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


  #2  
Old 30th September 2003, 05:49 AM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Questions

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
>
>



  #3  
Old 30th September 2003, 06:14 AM
Lee
 
Posts: n/a
Default Re: Questions


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

Thanks for the response,

Lee


  #4  
Old 30th September 2003, 07:59 AM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: Questions

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
>
>



  #5  
Old 30th September 2003, 08:32 AM
Lee
 
Posts: n/a
Default Re: Questions


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


  #6  
Old 30th September 2003, 08:46 AM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: Questions

> 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


  #7  
Old 30th September 2003, 08:47 AM
Hannes Danzl[NDD]
 
Posts: n/a
Default Re: Questions

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
>
>



  #8  
Old 30th September 2003, 01:09 PM
Lee
 
Posts: n/a
Default Re: Questions

Excellent Info, Hannes.

Thank you, I will look at the manual.

Lee


  #9  
Old 30th September 2003, 05:19 PM
Lauchlan M
 
Posts: n/a
Default Re: Questions

> 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


  #10  
Old 1st October 2003, 12:00 PM
Lee
 
Posts: n/a
Default Re: Questions


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
>
>





Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
questions on Chat Hannes Danzl[NDD] nexusdb.public.support.portal 5 14th October 2010 08:52 AM
Some Questions Danijel Tkalcec nexusdb.public.support.portal 2 3rd October 2009 12:46 AM
Some questions Alessandro Romano nexusdb.public.support.thirdparty 10 6th August 2005 03:36 AM
Questions... Curt nexusdb.public.support.odbc 1 30th May 2004 09:57 AM
Some SQL questions Stefan Paege nexusdb.public.support.sql 3 6th February 2004 12:45 AM


All times are GMT +11. The time now is 02:45 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.