Namma Suvarna Karnataka
Originally posted by Arjunkumar Shastry:
{
....based on date and time but again I found that many time more than one user update the list simultaniously and it causes the only one item to be updated
}
So what is the problem? You have to search for that record with max(timestamp),right?
Originally posted by Arjunkumar Shastry:
Write Stored procedure to scan entire table and call stored procedure from your java code.
Namma Suvarna Karnataka
Originally posted by Arjunkumar Shastry:
On an average,whats the row count of a table daily?
Which database are you using?
Originally posted by Arjunkumar Shastry:
I think it will be moved to JDBC if I am not wrong.
Originally posted by Sameer Jamal:
Thanks Amit its a good suggestion but sharing a global object among various users slow down the things little bit but its a good idea.
Another approach in my mind was building a seperate table for list updation every time a new item is added it will also be added into that table for each logged on user , user will then check the item from that table and delete their corresponding entry when the list is updated.
Consider Paul's rocket mass heater. |