Memos & Block sizeThis is a discussion on Memos & Block size within the xharbour forums in Programming Languages category; Dear Friends: In a downloaded web page, I note widely-varying sizes for certain text fields (e.g., one of my needed fields is from 0-length up to about 900 characters). (I've about 23K to 24K pages to be examined and parsed). I'm going to (cringe) finally get into 'Memo' fields for one of these items when I place these long descriptions away in a database. Any guidance on how big these Memo Blocks should be ?? Also, since I've stayed away from Memo Fields all these years, I know 'zip' about their usage. But I've got to start now. Any hints ... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
08-11-2008, 01:12 PM
| |||
| |||
 Memos & Block size Dear Friends: In a downloaded web page, I note widely-varying sizes for certain text fields (e.g., one of my needed fields is from 0-length up to about 900 characters). (I've about 23K to 24K pages to be examined and parsed). I'm going to (cringe) finally get into 'Memo' fields for one of these items when I place these long descriptions away in a database. Any guidance on how big these Memo Blocks should be ?? Also, since I've stayed away from Memo Fields all these years, I know 'zip' about their usage. But I've got to start now. Any hints will be appreciated ! TIA, -Mel Smith  |
|
#2
08-11-2008, 01:37 PM
| |||
| |||
| Re: Memos & Block size Dear Mel Smith, AFAIK: DBFNTX uses fixed memo blocks of 512 bytes for .DBT, for example a string of 600 bytes will occupy 1024 bytes DBFCDX by default uses memo blocks of 64 bytes for .FPT; upper limit is 1024, using smaller values than 33 aren't useful ADS by default uses memo blocks of 8 bytes for .ADM, upper limit is 1024 SET MEMOBLOCK or DBInfo( DBI_MEMO_BLOCKSIZE [, nNewValue] ) --> nOldValue manage the memo block size IMHO when there is no need to do many updates, the smaller value is the better. Ella "Mel Smith" <medsyntel@aol.com> wrote in message news:6gba8mFf1bccU1@mid.individual.net... > Dear Friends: > > In a downloaded web page, I note widely-varying sizes for certain text > fields (e.g., one of my needed fields is from 0-length up to about 900 > characters). (I've about 23K to 24K pages to be examined and parsed). > > I'm going to (cringe) finally get into 'Memo' fields for one of these > items when I place these long descriptions away in a database. > > Any guidance on how big these Memo Blocks should be ?? > > Also, since I've stayed away from Memo Fields all these years, I know > 'zip' about their usage. But I've got to start now. > > Any hints will be appreciated ! > > TIA, > > -Mel Smith > |
|
#3
08-11-2008, 03:24 PM
| |||
| |||
| Re: Memos & Block size Ella said: > DBFNTX uses fixed memo blocks of 512 bytes for .DBT, for example a string > of 600 bytes will occupy 1024 bytes > DBFCDX by default uses memo blocks of 64 bytes for .FPT; upper limit is > 1024, using smaller values than 33 aren't useful > ADS by default uses memo blocks of 8 bytes for .ADM, upper limit is 1024 > > SET MEMOBLOCK > or > DBInfo( DBI_MEMO_BLOCKSIZE [, nNewValue] ) --> nOldValue > manage the memo block size > > IMHO when there is no need to do many updates, the smaller value is the > better. Ella: After downloading (using internet explorer) all 23K sequential pages (with many different fields and one memo field), and then placing each of them into their own record in a memo field, there will be almost *no* updating. So, from what you've said above, I guess I should just let the dbfcdx size stay at 64 bytes. Does that seem reasonable ? Thanks ! -Mel Smith |
|
#4
08-11-2008, 07:56 PM
| |||
| |||
| Re: Memos & Block size > So, from what you've said above, I guess I should just let the dbfcdx > size stay at 64 bytes. Does that seem reasonable ? I hope so :-) > > Thanks ! > > -Mel Smith > > HTH Ella |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 04:04 PM.
