Help coderanch get a
new server
by contributing to the fundraiser

Sushma Lakshmi

Greenhorn
+ Follow
since Dec 21, 2007
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Sushma Lakshmi

Hi
Can anyone please provide pointers on how to populate drop down select boxes based on values set in collections. Any code snippet that depicts how the state of the selected option can be retained would be great.

This is my first spring webapp, and my current workaround is to have the html <select><option>...., retrieve the value in the controller and set it in the command. This value is retrieved in the jsp using scriptlets and renderd back. I do realize that this is not the most optimal solution so any pointers will be appreciated.


Thanks in advance.
Hi Bill,

The data is inserted every second into the 7 tables. There will be more inserts and selects on these tables than updates.

Thanks.
16 years ago
Thanks Ilja. Btw, can you recommend any good caching API/s.

I will be posting the results of my benchmark tests. However, I think it might take me a couple of days to get the tests setup and completed.
16 years ago
Thanks Ilja for responding.
Since this operation and consequently query is going to be executed very frequently (thousands of times every second), I am concerned that it might tax the database engine to breakdown . Fyi, most of the joins in the query are outer joins.

I am planning on doing some benchmarking today to check out the point of failure.
16 years ago
Hi,

I have a workflow within my app which requires me to retrieve data from 7 tables. This operation will be done very frequently so I am hesitant to do a 7 table join as a dynamic query or a view.

I am looking for patterns/best practices on retrieving the data from the 7 tables with minimum resource usage and locking.

Any guidance/pointers will be greatly appreciated.

Thanks.
Sushma
16 years ago