> I have a web app that several customers use, one customer
> alone has over
> 3000 stores. As it is, if they what to get a list of work orders for a
> store, they type in the store number, then submit the form and are
> returned the results. This takes a couple of seconds. I dont
> want to try
> to load all the possibilities in a Javascript, this would
> take even longer
> on the initial load.
>
> So * I was reading * on distributed objects in web applications, the
> specific example uses zip codes for city state lookup and is
> on the order
> of milliseconds. The example uses DCOM and I did not know if there is
> anything like this in perl.
>
> Does that clarify?
That definitely clarifies things -- but I don't think distributed objects
are going to solve your problem.
You appear to have good, old-fashion performance and user interface issues.
As I understand it, the problem is two-fold:
1. It takes too long to query the list of work-orders
2. The user has to drill down through the list of stores, first.
If this is correct, you need to address these issues directly. For
starters, "distributed"-anything is MORE code, and MORE code is inherently
SLOWER code. To speed your code, I would recommend putting your data in a
relational database (if it is not already), and properly indexing the data.
A "SELECT" on an index of only 3000 items should take about a tenth of a
second on a properly indexed relational database (not including data transit
time).
Regarding the drill-down problem, this can only be solved by working out a
better user interface design. UI design is a huge subject, and can't really
be used in the abstract to solve your problem. It's a matter of looking at
the specific task and coming up with a specific and intuitive way for your
users to do their most common tasks most easily, yet allowing other tasks to
still be accomplished. Perhaps you can provide some shortcuts into a
particular store? Maybe you need paging interfaces to step through your
result set? ("Click to get the next X work orders.") Just some ideas.
Did I understand your problem correctly, or is it something else?
Warmest regards,
-Jesse-
----
Jesse Erlbaum, CTO
Vanguard Media
212.242.5317 x115
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
