NTX vs. CDX

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

Post Reply
melliott42
Posts: 119
Joined: Wed Feb 18, 2009 2:14 pm

NTX vs. CDX

Post by melliott42 » Wed Jul 14, 2010 2:59 pm

Hello,

I used Clipper back in the DOS days. I was happy with the .NTX index files. I heard for large indexes they became corrupt. Hopefully that has been fixed.

1. Is there any compelling reason to not use NTX indexes?
2. Would CDX put all the indexes in just one file (or one for each index as NTX does)?

Thanks,

Michael

User avatar
esgici
Posts: 4518
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 391 times
Been thanked: 111 times
Contact:

Post by esgici » Wed Jul 14, 2010 4:18 pm

Hello Michael
melliott42 wrote: I used Clipper back in the DOS days. I was happy with the .NTX index files.
Welcome our club :)
melliott42 wrote: I heard for large indexes they became corrupt. Hopefully that has been fixed.
Itsn't for only .NTXs, every index file (in fact every file) may corrupt.
melliott42 wrote: 1. Is there any compelling reason to not use NTX indexes?
Simply no. No drastic reason for not use nor use.
melliott42 wrote: 2. Would CDX put all the indexes in just one file (or one for each index as NTX does)?
It's correct. "C" in the beginning means "compound".

But only advantage isn't "all indexs is in single file" (beside putting all eggs in one basket), CDX indexs has more.

Moreover, if you use same name of .dbf as index file name (fe mytable.cdx for mytable.dbf) and set AUTOPEN on, the cdx file will open (set) with table automatically.

The price is, you have learn same extra concepts : bag, tag, order (slightly different than classical meaning) ...

Anyway, after learned, you don't will be repentant, I thing ;)

Regards

--

Esgici
Viva INTERNATIONAL HMG :D

User avatar
cdsaenz
Posts: 58
Joined: Sun Jul 11, 2010 4:02 am

Post by cdsaenz » Wed Jul 14, 2010 11:36 pm

I agree that NTX ain't bad per se. I know serious applications with lot of data using big indexes. Reindexing from time to time is a good practice in those cases.

CDX is monolithic and should be faster/smaller. The bag stuff is nice and autoopen too.

Esgici, a question for you: how reliable is CDX implementation in Harbour? I ain't had the chance to really check that out. I believe it's production quality but just wanted to check out.

Thanks.
Charly
Argentina, Hobbyist developer, Clipper/Delphi/PHP/Progress

User avatar
esgici
Posts: 4518
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 391 times
Been thanked: 111 times
Contact:

Post by esgici » Wed Jul 14, 2010 11:50 pm

cdsaenz wrote: ...
how reliable is CDX implementation in Harbour? I ain't had the chance to really check that out. I believe it's production quality but just wanted to check out.
Hola Charly

Sadly I haven't any deeply experience, fe huge files, many tags and especially many years of usage, etc :(

But I always trust Harbour programmers; they are really very skilled persons. I havn't encountered any problem on implementation or performance problem against Clipper, especially database processing area.

Saludos

--

Esgici
Viva INTERNATIONAL HMG :D

User avatar
cdsaenz
Posts: 58
Joined: Sun Jul 11, 2010 4:02 am

Post by cdsaenz » Thu Jul 15, 2010 12:44 am

Good feedback, thanks Esgici. Yes, I see the Harbour team has made a tremendous job for a loong time. It's time to develop! :)
Charly
Argentina, Hobbyist developer, Clipper/Delphi/PHP/Progress

User avatar
mustafa
Posts: 860
Joined: Fri Mar 20, 2009 11:38 am
DBs Used: DBF
Location: Alicante - Spain
Been thanked: 132 times
Contact:

Post by mustafa » Thu Jul 15, 2010 9:46 am

Hola melliott42
Consulta estos Post
viewtopic.php?f=5&t=873
http://hmglights.wordpress.com/2010/03/ ... x-com-hmg/
viewtopic.php?f=5&t=1259
Saludos
*------------------- Google ---------------*
Hello melliott42
Check out these Post
viewtopic.php?f=5&t=873
http://hmglights.wordpress.com/2010/03/ ... x-com-hmg/
viewtopic.php?f=5&t=1259
Regards
Mustafa

melliott42
Posts: 119
Joined: Wed Feb 18, 2009 2:14 pm

Post by melliott42 » Thu Jul 15, 2010 12:01 pm

Esgici,

Thanks for the info on CDX and NTX. That is very useful.

Michael

Post Reply