What is a huge Table
flowersoft at compuserve.com
flowersoft at compuserve.com
Sat Dec 4 21:40:57 PST 2010
I have an input table that has 4,245 lines and the tok table is 242,400
bytes.
It is only at that number of lines because of extensive use of called and
chained tables within it. I even have called tables for @wef and @wlf
processing in many cases.
If you are not using version 5.6, you might run into problems if the size
gets larger than 260,000 bytes. I did.
-----Original Message-----
From: filepro-list-bounces+flowersoft=compuserve.com at lists.celestial.com
[mailto:filepro-list-bounces+flowersoft=compuserve.com at lists.celestial.com]
On Behalf Of Dennis DIller
Sent: Friday, December 03, 2010 9:45 PM
To: filepro-list at lists.celestial.com
Subject: What is a huge Table
what is considered a large prc table
Lines of code _ _ _ _ _
KB SIZE _ _ _ _ _
I have One file 159 KB in prc.input
125 KB in Tok
Each are 2900 lines of code
--------------------------------------------------
From: <filepro-list-request at lists.celestial.com>
Sent: Friday, December 03, 2010 6:49 PM
To: <filepro-list at lists.celestial.com>
Subject: Filepro-list Digest, Vol 83, Issue 3
> Send Filepro-list mailing list submissions to
> filepro-list at lists.celestial.com
>
> To subscribe or unsubscribe via the World Wide Web, visit
> http://mailman.celestial.com/mailman/listinfo/filepro-list
> or, via email, send a message with subject or body 'help' to
> filepro-list-request at lists.celestial.com
>
> You can reach the person managing the list at
> filepro-list-owner at lists.celestial.com
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of Filepro-list digest..."
>
>
> Today's Topics:
>
> 1. filepro on the web (Enrique Arredondo)
> 2. Re: HUGE tok tables (Kenneth Brody)
> 3. mid (Richard Kreiss)
> 4. Re: mid (Kenneth Brody)
> 5. Re: mid (Bruce Easton)
> 6. Re: HUGE tok tables - ooops (Scott Nelson)
> 7. RE: mid (Richard Kreiss)
> 8. Re: filepro on the web (Bruce Easton)
> 9. Re: OT: HDMI ports (C Day)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Fri, 3 Dec 2010 15:20:17 -0600 (CST)
> From: Enrique Arredondo <henry at vegena.net>
> Subject: filepro on the web
> To: filepro-list at lists.celestial.com
> Message-ID: <Pine.SC5.4.60.1012031513350.4145 at atksco1>
> Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
>
> Has anyone tried creating filepro menus over a browser and emulating that
> you are in a filepro menu but in reality it's the same filepro lookalike
> menu but there are just links that will do cgi scripts and then do what a
> normaly menu script will do ?
>
> I'm going to give it a try but I wanted to know if someone already did it
> and I can grab some ideas.
>
> thanks
>
>
>
>
> ------------------------------
>
> Message: 2
> Date: Fri, 03 Dec 2010 16:48:03 -0500
> From: Kenneth Brody <kenbrody at spamcop.net>
> Subject: Re: HUGE tok tables
> To: Scott Nelson <scott at logicdatasystems.com>
> Cc: Filepro-list at lists.celestial.com
> Message-ID: <4CF96593.6000201 at spamcop.net>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> On 12/3/2010 3:10 PM, Scott Nelson wrote:
>> fP 5.0.14 on SCO OpenServer 6
>>
>>
>> I see that most tok tables are smaller than their prc table. On one
>> file that happens to be a virtual file, any prc that I tok is Many times
>> larger, and there is other odd activity, like extremely slow lookups.
>> The automatic table is empty.
>>
>> What could cause the toks to be so much larger?
>
> Something in the prc that generates lots of code and/or data. Perhaps an
> array with a lot of elements? Without any actual examples, we can only
> guess.
>
> --
> Kenneth Brody
>
>
> ------------------------------
>
> Message: 3
> Date: Fri, 3 Dec 2010 16:52:35 -0500
> From: "Richard Kreiss" <rkreiss at gccconsulting.net>
> Subject: mid
> To: <Filepro-list at lists.celestial.com>
> Message-ID: <00e001cb9334$65593a40$300baec0$@gccconsulting.net>
> Content-Type: text/plain; charset="iso-8859-1"
>
> Have a program using the following type of code
>
> If:
> Then: dim who(6);who["6"]="Cancel"
>
> This array is then filled in the form NNNN name
>
> If:
> Then: sl(1,.0)=listbox(who)
> If:
> Then: 3=mid(who[sl],"1","4");ab=mid(who[sl],"6","30")
>
> Why am I getting a syntax error that points to [sl]?
>
>
> Richard Kreiss
> GCC Consulting
> rkreiss at gccconsulting.net
> ?
>
>
>
>
>
>
> ------------------------------
>
> Message: 4
> Date: Fri, 03 Dec 2010 17:11:42 -0500
> From: Kenneth Brody <kenbrody at spamcop.net>
> Subject: Re: mid
> To: rkreiss at gccconsulting.net
> Cc: Filepro-list at lists.celestial.com
> Message-ID: <4CF96B1E.80701 at spamcop.net>
> Content-Type: text/plain; charset=UTF-8; format=flowed
>
> On 12/3/2010 4:52 PM, Richard Kreiss wrote:
>> Have a program using the following type of code
>>
>> If:
>> Then: dim who(6);who["6"]="Cancel"
>>
>> This array is then filled in the form NNNN name
>>
>> If:
>> Then: sl(1,.0)=listbox(who)
>> If:
>> Then: 3=mid(who[sl],"1","4");ab=mid(who[sl],"6","30")
>>
>> Why am I getting a syntax error that points to [sl]?
>
> Perhaps you are running an ancient version of filePro?
>
> This small test generates no error in 5.6 or 5.0, though it does in 4.8:
>
> 1 ------- - - - - - - - - - - - - -
> ? If:
> Then: dim who(6)
> 2 ------- - - - - - - - - - - - - -
> ? If:
> Then: sl(1,.0) = listbox(who)
> 3 ------- - - - - - - - - - - - - -
> ? If:
> Then: xx = mid(who[sl],"1","4"); yy = mid(who[sl],"6","30")
>
> Unless, that is, you have a typo, and have "s1" rather than "sl".
>
> --
> Kenneth Brody
>
>
> ------------------------------
>
> Message: 5
> Date: Fri, 03 Dec 2010 17:13:02 -0500
> From: Bruce Easton <bruce at stn.com>
> Subject: Re: mid
> To: Filepro-list at lists.celestial.com
> Message-ID: <4CF96B6E.2010207 at stn.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I don't remember which version, but sometime prior to 5.0, you
> could not reference certain expressions for the first argument of
> the mid function (including array or lookup references).
>
> Maybe that is the problem. Try assigning the array reference
> to a dummy field and then use the dummy inside mid.
>
> Bruce
>
>
> Bruce Easton
> STN, Inc.
>
>
>
>
> On 12/3/10 4:52 PM, Richard Kreiss wrote:
>> Have a program using the following type of code
>>
>> If:
>> Then: dim who(6);who["6"]="Cancel"
>>
>> This array is then filled in the form NNNN name
>>
>> If:
>> Then: sl(1,.0)=listbox(who)
>> If:
>> Then: 3=mid(who[sl],"1","4");ab=mid(who[sl],"6","30")
>>
>> Why am I getting a syntax error that points to [sl]?
>>
>>
>> Richard Kreiss
>> GCC Consulting
>> rkreiss at gccconsulting.net
>>
>>
>>
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>>
>
>
>
> ------------------------------
>
> Message: 6
> Date: Fri, 03 Dec 2010 16:20:13 -0600
> From: Scott Nelson <scott at logicdatasystems.com>
> Subject: Re: HUGE tok tables - ooops
> To: Kenneth Brody <kenbrody at spamcop.net>
> Cc: Filepro-list at lists.celestial.com
> Message-ID: <4CF96D1D.8000809 at logicdatasystems.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> I totally forgot that the arrays are built out in the tok file. And I
> had some Huge arrays in there.
>
> I did notice a processing slow down with them large, and I need to test
> the system limits on this. Perhaps hitting a buffer size with filePro?
>
>
>
> On 12/3/2010 3:48 PM, Kenneth Brody wrote:
>> On 12/3/2010 3:10 PM, Scott Nelson wrote:
>>> fP 5.0.14 on SCO OpenServer 6
>>>
>>>
>>> I see that most tok tables are smaller than their prc table. On one
>>> file that happens to be a virtual file, any prc that I tok is Many times
>>> larger, and there is other odd activity, like extremely slow lookups.
>>> The automatic table is empty.
>>>
>>> What could cause the toks to be so much larger?
>>
>> Something in the prc that generates lots of code and/or data. Perhaps
>> an array with a lot of elements? Without any actual examples, we can
>> only guess.
>>
>
>
>
> ------------------------------
>
> Message: 7
> Date: Fri, 3 Dec 2010 17:28:21 -0500
> From: "Richard Kreiss" <rkreiss at gccconsulting.net>
> Subject: RE: mid
> To: "'Kenneth Brody'" <kenbrody at spamcop.net>
> Cc: Filepro-list at lists.celestial.com
> Message-ID: <00e701cb9339$64ab54c0$2e01fe40$@gccconsulting.net>
> Content-Type: text/plain; charset="utf-8"
>
>
>
>> -----Original Message-----
>> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
>> Sent: Friday, December 03, 2010 5:12 PM
>> To: rkreiss at gccconsulting.net
>> Cc: Filepro-list at lists.celestial.com
>> Subject: Re: mid
>>
>> On 12/3/2010 4:52 PM, Richard Kreiss wrote:
>> > Have a program using the following type of code
>> >
>> > If:
>> > Then: dim who(6);who["6"]="Cancel"
>> >
>> > This array is then filled in the form NNNN name
>> >
>> > If:
>> > Then: sl(1,.0)=listbox(who)
>> > If:
>> > Then: 3=mid(who[sl],"1","4");ab=mid(who[sl],"6","30")
>> >
>> > Why am I getting a syntax error that points to [sl]?
>>
>> Perhaps you are running an ancient version of filePro?
>>
>> This small test generates no error in 5.6 or 5.0, though it does in 4.8:
>>
>> 1 ------- - - - - - - - - - - - - -
>> ? If:
>> Then: dim who(6)
>> 2 ------- - - - - - - - - - - - - -
>> ? If:
>> Then: sl(1,.0) = listbox(who)
>> 3 ------- - - - - - - - - - - - - -
>> ? If:
>> Then: xx = mid(who[sl],"1","4"); yy = mid(who[sl],"6","30")
>>
>> Unless, that is, you have a typo, and have "s1" rather than "sl".
>>
>> --
>> Kenneth Brody
>
> Problem solved, checked the map. It appears that I added a field who and
> never adjusted this program. When I changed the array to whose(6) and
> adjusted the program to use this array name, no syntax error.
>
> My question is why the syntax error at who[sl] and not who("6"]="cancel"
> which is prior to the who[sl]. Only at the point where it needed to
> resolve which element did the error occur.
>
> Richard
>
>
>
>
>
> ------------------------------
>
> Message: 8
> Date: Fri, 03 Dec 2010 18:44:43 -0500
> From: Bruce Easton <bruce at stn.com>
> Subject: Re: filepro on the web
> To: filepro-list at lists.celestial.com
> Message-ID: <4CF980EB.1080706 at stn.com>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Enrique,
>
> I'm sure there are quite a number of people who have written browser
> apps to emulate filepro in various ways. And I know there are some who
> have done a lot of it. And there are some who have done a lot of it and
> worked for years on development programs to help them standardize and
> make efficient that type of development**.
>
> What is your goal for this? Do you already have working cgi scripts
> and just need to emulate the menus? I ask, because, for any
> browser-based app, depending on your needs, there can be a number of
> different disciplines involved. I'll try to answer any specific
> questions you may have.
>
> **<adv>
> Also, you might want to take a look at our fPageBuilder page at:
>
> http://www/stn.com/products/dbinet.htm
>
> for ideas. Included there are live demo apps and PDFs
> which explain and illustrate the development program.
>
> fPageBuilder is not yet for purchase, but will be very soon. Currently,
> most of my time is spent using fPageBuilder for specific
> client needs on a services basis, or in working towards completion
> the manual.
> </adv>
>
>
> Bruce
>
> Bruce Easton
> STN, Inc.
>
>
>
> On 12/3/10 4:20 PM, Enrique Arredondo wrote:
>> Has anyone tried creating filepro menus over a browser and emulating that
>> you are in a filepro menu but in reality it's the same filepro lookalike
>> menu but there are just links that will do cgi scripts and then do what a
>> normaly menu script will do ?
>>
>> I'm going to give it a try but I wanted to know if someone already did it
>> and I can grab some ideas.
>>
>> thanks
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>>
>
>
>
> ------------------------------
>
> Message: 9
> Date: Fri, 03 Dec 2010 15:44:16 -0500
> From: C Day <gliderman.one at frontier.com>
> Subject: Re: OT: HDMI ports
> To: filepro-list at lists.celestial.com
> Message-ID: <4CF956A0.7070801 at frontier.com>
> Content-Type: text/plain; charset="iso-8859-1"
>
> On 12/3/2010 11:43 AM, Richard Kreiss wrote:
>> I ordered a Sony sound bar for my Sony LCD. This should have been a
>> simple
>> installation. One HDMI cable from the home theater system out to the
>> flat
>> panel HDMI in.
>>
>> He's where the fun began, I could get sound but no video. Although the
>> TV
>> saw the home theater system, it still only would receive sound.
>>
>> Yesterday I called B&H Photo who I ordered the system from and got an
>> RMA.
>> After repacking everything, I realized that these LCD's are nothing more
>> than a computer with a large monitor attached. So, I unplugged the set
>> for
>> a minute and then unpacked the sound system again and connected it. It
>> worked perfectly.
>>
>> I felt really stupid in that we would tell a client, when they say a
>> peripheral isn't working, shutdown the computer and then restart it after
>> a
>> few minutes.
>>
>> Why the email, just a reminder if you are attaching any Christmas
>> presents
>> to you TV through an HDMI connection and get no video, unplug the set
>> first,
>> not just turning it off with the remote, before thinking that the new
>> device
>> isn't working. Electronics go into standby mode and are not fully
>> powered
>> off when they are "turned off".
>>
>>
>> Richard Kreiss
>> GCC Consulting
>> rkreiss at gccconsulting.net
>>
>
> Richard, the instruction book for my Vizio and sound bar tells you
> to unplug and wait for 20-30 seconds before plugging in again.
>
> Charles Day
> -------------- next part --------------
>
> No virus found in this outgoing message.
> Checked by AVG - www.avg.com
> Version: 9.0.872 / Virus Database: 271.1.1/3294 - Release Date: 12/03/10
> 02:34:00
>
>
> ------------------------------
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
>
> End of Filepro-list Digest, Vol 83, Issue 3
> *******************************************
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1170 / Virus Database: 426/3295 - Release Date: 12/03/10
>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list