I'm about 24 hours away from launching a new site (virtual host) on my Active4D client. (OSX 10.4.10, 2004 client as web server, Active4D 4.0.3 - Apache front end (https) to Active4D)

I won't go into details, but my site is an intranet set supporting about 150 users. Never have more than about 40 session going at a time with about 5k per session.

I decided we could handle an online application process for a customer that expects to get about 5,000 applications over the next week and totaling about 10,000 over the next 3 weeks. (ThyssenKrupp Steel & Stainless plant in Mobile Al if anyone interested)

The application spans 5 pages and has about 120 elements - half of which are blank or a 2 character answer. I just stuck each page element in the session, not realizing that 120 session elements is about 32K per session!

Help!!!

If I get 500 people trying to fill out this application at the same time am I in deep kimshi?

This is not that big application. Fusebox with about 20 scripts (apply1...apply5 with supporting queries, etc). Stores data in a blob/ collection in a polymorphic table that is latter moved to real tables (if accepted).

If I'm in trouble, should I:

1 - store "f_@" attributes in a blob in the session with get and put? (to reduce element number and size)
        2 - store "f_@" attributes in table with get and put?
        3 - punt and hope it can handle it?

Steve Alex
AIDT
www.aidt.edu
_______________________________________________
Active4D-dev mailing list
[email protected]
http://mailman.aparajitaworld.com/mailman/listinfo/active4d-dev
Archives: http://mailman.aparajitaworld.com/archive/active4d-dev/

Reply via email to