[xtlb43n]

I’m using JSF/myFaces – I have a search screen that queries the database and potentially returns a large number of records (100-500) – I am using myFaces Tomahawk t:datatable and t:datascroller to scroll through the results. This all works well.

My question though is around scalability. I would like to save the search query and search results so that if the user goes to another page in the app and comes back, they will return to the same search results and same position within those search results. Basically I want to duplicate Google’s search results – if you visit links and come back, you are always returned to the same position in the search results. Obviously a session bean would work, but I have concerns about running out of memory with a large number of users on the site. Any suggestions / information / examples as to how to implement this without using a session bean, or implementing it such that it is scaleable to hundreds of users?

thanks

[Riyad Kalla]

Moving to OT > Soft Dev

[Haris Peco]

xtlb43n,

database will be this the best for you
good database will cache ifnormation, search, sort etc for you
if you have a lot users (or data) no one application servers will not do it good like database

if you choose database with scrollable resultset (mostly database support this), you can request page what you want
database must have good locking mechanism (MVC) for more users and more transaction (oracle, postgresql have MVC) – MVC is important for mores users – this enable that reader doesn’t block others readers and writers doesn’t lock others readers and writers .
oracle do this excellent, MS SQL is poor for this – what is your database ?

[xtlb43n]

mySQL 5.0 – I’ll need to check into mySQL’s capabilities for some of the features you mention above. Any experience / recommendations with mSQL 5.0?

[Haris Peco]

i’m sure that oracle is perfect, probably and postgreSQL (much better than MySQL for complex database) – you have to check MySql – MySql is probably good if your database schema is simple (no too much FK, procedures, no complex queries).

iI’m sure that oracle and postgreSQL use MVC, MS SQL , MySQL and Sybase haven’t MVC
i don’t know for DB2

best

[Author]

Posts