crojas70
asked on
Slow Response on HTTP Application
Hi Xperts, i have a situation here. I've built a complete Human Resources ERP like system using Lotus Domino R5.012 completly for Web with the following characteristics :
a) i use only 1 Notes user, (the server) and the anonymous and each person has a profile document where it is located its own password.
b) there are about 50 logins daily but in diferent times (separated by seconds)
c) The mainly function is that there you have all your personal data in one database and all the collaboration and work documents in other 10 different databases in the same server.
d) For Front-end i use javascript (of course) with AJAX callings to the other databases so i can retrieve the data
e) For document save and send i use Lotusscript with one library per datanase and a lot of agents calling the functions in the library
f) In some process the application send emails to the HR people and external people
g) i have connections to SQL using NotesSQL and some text files writing
So the problem i´m having extactly is that each time i call for a lotusscript processing the application gets slow
sometimes the Domino Administrator has to restart the HTTP service and , in other cases the complete server inlcuding Windows 2003 Server.
I am trying to convince the my bosses that we have to uograde to version 6x, but will it be the answer?
Could it be that i'm using one Notes User for the entire organization? For security im using cookies on each client that access the web application and putting some HTML header security
Thanks for your help
Charlie
a) i use only 1 Notes user, (the server) and the anonymous and each person has a profile document where it is located its own password.
b) there are about 50 logins daily but in diferent times (separated by seconds)
c) The mainly function is that there you have all your personal data in one database and all the collaboration and work documents in other 10 different databases in the same server.
d) For Front-end i use javascript (of course) with AJAX callings to the other databases so i can retrieve the data
e) For document save and send i use Lotusscript with one library per datanase and a lot of agents calling the functions in the library
f) In some process the application send emails to the HR people and external people
g) i have connections to SQL using NotesSQL and some text files writing
So the problem i´m having extactly is that each time i call for a lotusscript processing the application gets slow
sometimes the Domino Administrator has to restart the HTTP service and , in other cases the complete server inlcuding Windows 2003 Server.
I am trying to convince the my bosses that we have to uograde to version 6x, but will it be the answer?
Could it be that i'm using one Notes User for the entire organization? For security im using cookies on each client that access the web application and putting some HTML header security
Thanks for your help
Charlie
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
First, you accepted my answer, but I assume it's a mistake. In that case, put a question in the Community Service topic area to "unaccept" your question.
1) You use NotesSQL from Notes, or is there another application that uses NotesSQL to get to your data?
2) Even then, the use of libraries can be slow
3) Whether or not the WebQuerySave is present, the document is ALWAYS saved. The only way to get some grip on the document in "real-time" is to use the WebQuerySave agent. Post-processing new documents is also possible, using other agents. It may take a while before they kick in, depending on the load of the server.
4) Still, a cookie mechanism is a security mechanism, and therefore requires a CAL. I think it's got little to do with the real question here, so let's drop that part of the discussion. Although... why did you decide to use cookies?? Now you have a great Domino server with perfect built-in security and what do you do? You throw it away??
5) Awesome! Can't be the problem...
6) ...
In fact, I'd love to analyze this application, but from a distance that would be practically impossible (unless...)
1) You use NotesSQL from Notes, or is there another application that uses NotesSQL to get to your data?
2) Even then, the use of libraries can be slow
3) Whether or not the WebQuerySave is present, the document is ALWAYS saved. The only way to get some grip on the document in "real-time" is to use the WebQuerySave agent. Post-processing new documents is also possible, using other agents. It may take a while before they kick in, depending on the load of the server.
4) Still, a cookie mechanism is a security mechanism, and therefore requires a CAL. I think it's got little to do with the real question here, so let's drop that part of the discussion. Although... why did you decide to use cookies?? Now you have a great Domino server with perfect built-in security and what do you do? You throw it away??
5) Awesome! Can't be the problem...
6) ...
In fact, I'd love to analyze this application, but from a distance that would be practically impossible (unless...)
ASKER
1- I use NotesSQL because some documents, when they have been processed, some of their data must be written in an other application that uses SQL Server (its a Payroll system built in Visual Basic with MSSQL 2000)
2- Each database has its own library and the agents of each Database uses only their library
3- Must FORMS have an Agent Call in the WebQuerySave because there is where the document save is done apart from other data processing
4.- The use of cookies is necesary beacuse there a lot of people in the Factories that do not use a computer (so do not have a Lotus id) so they put one for everybody to register their extra hours timing in our web application. The cookies recognize who is logged in the application. Maybe this kind of security creates the extra load, but has worked fine (on security basis)
5.- The hardware is big, big in RAM and speed, kind of 2Gb RAM and 2 processors at 2Ghz each
6.- Furthermore, i'm using a database of contents so i developed a group of Documents each having a URL that links to forms, agents or views of the other databases. each document has its security related to the person logged in.
i´m thinking, as you say, that a mixture of things is creating this problem. The users sometimes get desperate so i must find a way of solving this because the application is very good in its function and trying to change it to other plataform could be time consuming (the app took about 3 years to build and the last 10 lotus prgrammers in the area)
Version 6x is being authorized (that means Lotus continues in the company, thats good) so i wll start making tests and get back here.
Thanks a lot
Charlie