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

new topic     » topic index » view message » categorize

Search



Quick Links

User menu

Not signed in.

Misc Menu