Hello All, I am new here, and am very interested in OpenACS as an
intranet server for the company that just hired me. I have built
reasonably sophisticated database backed websites (with *.asp)
before, but will be required to make something a bit more complicated
for this job, and would like it if I could use something like OpenACS
as my starting point instead of building it from scratch. I was
wondering about large data sets and Postgres/OpenACS. First, can it
deal with tables with more than 1,000,000 rows? How about 5,000,000?
If it can, will this be a huge stress on the server requiring very
sophisticated hardware, or can any decent box Intel/ with a couple
fast scsi disks and 1GB Ram deal with this? There will only be about
20 people entering and updating data and maybe 500 accessing it
(clients and employees) - it will likely be the equivalent of 2
people working full time entering data all day long (i.e. those 20
people will enter data for about 10% of their day). I would then like
to be able to create reports that deal with just 50-500 rows at a
time these rows would be chosen based on a common job_id field in the
database. So my queries would be
# Select * from my_table_name where job_id = '16892234' ;
I donÂt think I would ever want to pull out more than 500-1000 rows
at a time. They tell me that the data will grow at a rate of about
100,000 entries per month. I was also wondering if anybody uses
OpenACS as an accounting program, or if one can buy a pretty front
end software program that will query the Postgres Database and pull
out data as needed, and then allow the financial people to analyze
the data? They would need similar functionality to Quickbooks - just
as almost all businesses need. If not, is that because this would be
something that is prohibitively difficult to build?
Thanks for the help.
