Hi C and Michey, Thx for the informative comments. Let me be little more specific. I need to to make a databse system where i can store SMS/MMS coming from network for all users. Later on the SMS/MMS will be forwarded to the specific user.
On 6/22/06, C.Peachment <[EMAIL PROTECTED]> wrote:
An important factor might be the frequency of message record insertion and/or deletion. A rate of several per minute should be no problem for a single database but several per second might cause unacceptable lockouts for readonly uses.
How many writing processes will access the database "simultaneously"? So this situation says that there can be multiple incoming SMS/MMS for different users at the same time. Also there can be multiple reads too all at the same time. Frequency may be high considering there might be thousands of users.
Open/close of multiple databases could be time consuming. that's the point.
Anything on security point of view. Can any user send some malicious script thru SMS which can corrupt the database. My main intention of using multiple databases is that if some user send some malicious script he should be able to corrupt only one DB and not others. Am i right in this assumption ? Looking forward to hear from you. Regards
