What is the maximum number of Tags i can have in a CDX file? Specifically for a FPW 2.6 database.
I can't find this number anywhere. Thanks
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---
Lots. For some strange reason, I don't have FPW handy, but you can try:
CREATE CURSOR fred (iKey i, string c(10)) FOR i = 1 TO 255 tagname = "TAG" + ALLTRIM(STR(i)) INDEX ON .t. TAG (tagname) NEXT DISPLAY STATUS
Worked for me, in VFP7. Try it in FPW and see what you get.
P.S. Sorry, Fred ;)
On Tue, Nov 1, 2016 at 1:02 PM, Michael Madigan mmadi10699@yahoo.com wrote:
What is the maximum number of Tags i can have in a CDX file? Specifically for a FPW 2.6 database.
I can't find this number anywhere. Thanks
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
Hmm...
Fred
On Tue, Nov 1, 2016 at 11:29 AM, Ted Roche tedroche@gmail.com wrote:
Lots. For some strange reason, I don't have FPW handy, but you can try:
CREATE CURSOR fred (iKey i, string c(10)) FOR i = 1 TO 255 tagname = "TAG" + ALLTRIM(STR(i)) INDEX ON .t. TAG (tagname) NEXT DISPLAY STATUS
Worked for me, in VFP7. Try it in FPW and see what you get.
P.S. Sorry, Fred ;)
On Tue, Nov 1, 2016 at 1:02 PM, Michael Madigan mmadi10699@yahoo.com wrote:
What is the maximum number of Tags i can have in a CDX file?
Specifically for a FPW 2.6 database.
I can't find this number anywhere. Thanks
--- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html
[excessive quoting removed by server]
As many as it takes to bust the 2GB file size ceiling probably.
Yes, that's the correct answer. It's as many you can create without going over 2.0 gb Thanks for everyone's help.
From: Alan Bourke alanpbourke@fastmail.fm To: profox@leafe.com Sent: Tuesday, November 1, 2016 6:44 PM Subject: Re: What is the maximum number of Tags i can have in a CDX file?
As many as it takes to bust the 2GB file size ceiling probably.
Yes, that's the correct answer. It's as many you can create without going over 2.0 gb
Tag names occupy space in the name table which is limited to 65,000 entries. Which is still a hypothetical limit as updating that many indexes slows down file operations quite a bit. With these day's Windows Servers you are also almost guaranteed index corruption. ;)