1. Open file limit
I use Business Basic on a daily basis for my company's mission-critical =
application. While I've redesigned a number of parts of the system to fix =
bugs and adapt the system to changing business needs, there are a number =
of things which the original designers did that would be difficult to =
change.
Business Basic (BBx), like many other database languages, opens all its =
files at once, with one file representing a single table. This can easily =
result in as many as 100 files being opened simultaneously. If I were to =
port this system to Euphoria (when I mentioned it to my boss once, he gave =
me this queer look), there would be a number of changes that would keep =
the 22 file limit (0,1, and 2 are already used for stdin, stdout, and =
stderr) realistic. I can include several tables into a single .edb file. =
The current system has a lot of duplicity (which was included to make up =
for the slow speed of BBx) that would be unnecessary in Euphoria. =
Finally, I would never use all 100 files simultaneously. So throughout my =
program, I would only open the files needed for a particular routine and =
import the necessary data into a memory-held sequence. And before the =
routine was finished, I would close all the files that were opened in that =
routine to free up the file ids. In Euphoria, especially in a business =
environment, keeping files open for the least amount of time necessary is =
just good programming practice.
HTH,
Michael J. Sabal
