on 04-26-2006 6:25 AM
Hai,
I am using table element to view the data retrieve by the webservice.
the database is maxdb it have around 5000 rows, when i tried to retrieve data the table does not showing the data, i tried to run the webservice from dispatcher, at that time i got the message like read timeout error.
any body please help me to encounter this problem.
regards,
Naga,
First, try to figure out where bottleneck occurs:
1. Execute same query in SQL Studio. Does it runs quickly? If not then problem is query complexity and query / database should be optimize (records indexing etc)
2. Try to execute same query from Java application via JDBC, application must run on WebAS server If this also works ok, then problem is probably XML marshaling/unmarhalling of data, otherwise it is slow connection between server and DB host.
VS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Naga,
Just to clarify scenario:
1. You have some (probably EJB) middle layer that expose data from database via WebService
2. You are consuming WebService in WebDynpro for data display.
3. Reducing data set in half (from 5000 records to 2500) make things work correctly.
So, you need to investigate what part is wrong:
-- middle layer serializes data inefficiently
-- WebDynpro part deserializes data inefficiently
-- both.
Solutions could be different, the most natural one is
to reduce number of fields transfered, exclude large texts and blob-like structures. Probably you may skip WebService transport alltogether, accessing middle tier directly via JavaBeans model rather then WS model.
VS
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.