This content has been marked as final.
Show 7 replies
-
1. Re: Architecture question
thejavafreak Oct 11, 2007 3:18 AM (in response to amitev)What does this has got to do with Seam? What is the relation to Seam?
-
2. Re: Architecture question
amitev Oct 11, 2007 3:19 AM (in response to amitev)It's not seam related actually but i think here is the best place to ask.
-
3. Re: Architecture question
amitev Oct 11, 2007 3:23 AM (in response to amitev)And when i "say the database will be changed every year" - the idea is every year to start with a clear for better performance.
-
4. Re: Architecture question
swd847 Oct 11, 2007 3:50 AM (in response to amitev)If you design your schema properly you probably shouldn't have to do anything like this. How much data are you talking about?
-
5. Re: Architecture question
amitev Oct 11, 2007 3:59 AM (in response to amitev)Like a 2 million records per in the tables
-
6. Re: Architecture question
swd847 Oct 11, 2007 4:07 AM (in response to amitev)That is not that many records, depending on what you want to do with them. As long as they are properly indexed etc and you are not doing any full table scans that should not be a problem.
-
7. Re: Architecture question
amitev Oct 11, 2007 4:14 AM (in response to amitev)There will be a search for fields in the tables - like searching in a various fields