Click here to Skip to main content
15,868,016 members
Home / Discussions / Database
   

Database

 
AnswerHow about a Temp table Pin
David Mujica6-Jun-23 3:40
David Mujica6-Jun-23 3:40 
GeneralRe: How about a Temp table Pin
jschell6-Jun-23 4:59
jschell6-Jun-23 4:59 
GeneralRe: How about a Temp table Pin
k50546-Jun-23 5:24
mvek50546-Jun-23 5:24 
GeneralRe: How about a Temp table Pin
jschell7-Jun-23 5:09
jschell7-Jun-23 5:09 
QuestionEntityFramewok Core 6 WPF App Pin
Kevin Marois18-May-23 16:57
professionalKevin Marois18-May-23 16:57 
AnswerRe: EntityFramewok Core 6 WPF App Pin
Richard Deeming18-May-23 21:11
mveRichard Deeming18-May-23 21:11 
QuestionChoosing a proper database for mobile messenger app Pin
Alex Dunlop17-Apr-23 5:53
Alex Dunlop17-Apr-23 5:53 
AnswerRe: Choosing a proper database for mobile messenger app Pin
jschell17-Apr-23 6:15
jschell17-Apr-23 6:15 
You can size it like the following

2000 users
100 messages a day
Total = 200,000 message a day
Messages per year = 400 * 200,000 = 80,000,000

Why 400? Because precision is not needed. All of the numbers are just guesses to give a goal.

Then further what is the average message size? 100 bytes or 1,000,000. Obviously the second is going to be because they are transferring files and not just messages. So do you keep the files also.

One thing I don't see in your post is growth rate. Are you starting with 200 users and only expect them to grow to 2000? Or the market that you are targeting, at best, only has about 2000 users?

You also do not document retention rates. How long do you keep the messages? 1 year? 7 years (often sufficient for most legal/business reasons)? 20 years?

So what database do you need? Any really. Nothing you posted suggests a need for 'speed'. All you are doing is keeping it for future analysis. You could even just write it to files.

You also do not mention personal security. Presumably, excluding the analysis, the messages are not subject to random poking around by operations personnel so how do you secure that?
GeneralRe: Choosing a proper database for mobile messenger app Pin
Alex Dunlop17-Apr-23 6:24
Alex Dunlop17-Apr-23 6:24 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Mycroft Holmes17-Apr-23 12:48
professionalMycroft Holmes17-Apr-23 12:48 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 4:58
jschell18-Apr-23 4:58 
AnswerRe: Choosing a proper database for mobile messenger app Pin
Eddy Vluggen17-Apr-23 23:27
professionalEddy Vluggen17-Apr-23 23:27 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 5:00
jschell18-Apr-23 5:00 
AnswerRe: Choosing a proper database for mobile messenger app Pin
Richard MacCutchan17-Apr-23 23:56
mveRichard MacCutchan17-Apr-23 23:56 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Code4Ever18-Apr-23 0:03
Code4Ever18-Apr-23 0:03 
GeneralRe: Choosing a proper database for mobile messenger app Pin
Richard MacCutchan18-Apr-23 0:29
mveRichard MacCutchan18-Apr-23 0:29 
GeneralRe: Choosing a proper database for mobile messenger app Pin
jschell18-Apr-23 5:15
jschell18-Apr-23 5:15 
QuestionHow do I retrieve the manipulated blob? Pin
lookilok4-Apr-23 21:09
lookilok4-Apr-23 21:09 
AnswerRe: How do I retrieve the manipulated blob? Pin
jschell5-Apr-23 6:35
jschell5-Apr-23 6:35 
GeneralRe: How do I retrieve the manipulated blob? Pin
lookilok5-Apr-23 21:51
lookilok5-Apr-23 21:51 
GeneralRe: How do I retrieve the manipulated blob? Pin
jschell6-Apr-23 5:20
jschell6-Apr-23 5:20 
AnswerRe: How do I retrieve the manipulated blob? Pin
Richard MacCutchan6-Apr-23 6:08
mveRichard MacCutchan6-Apr-23 6:08 
QuestionTSQL, Order by case, and I need to order by version Pin
jkirkerx21-Mar-23 8:09
professionaljkirkerx21-Mar-23 8:09 
AnswerRe: TSQL, Order by case, and I need to order by version Pin
Ron Nicholson21-Mar-23 8:22
professionalRon Nicholson21-Mar-23 8:22 
GeneralRe: TSQL, Order by case, and I need to order by version, [fixed] good enough for me, thanks Pin
jkirkerx21-Mar-23 8:36
professionaljkirkerx21-Mar-23 8:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.