Click here to Skip to main content
15,922,894 members
Home / Discussions / Database
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 3:10
cofounderChris Maunder16-Jul-09 3:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 16:30
cofounderChris Maunder10-Nov-05 16:30 
QuestionVb6 and sqlserver 2000 Pin
ahmed ali Apr20217-May-24 17:31
ahmed ali Apr20217-May-24 17:31 
AnswerRe: Vb6 and sqlserver 2000 Pin
Victor Nijegorodov7-May-24 20:07
Victor Nijegorodov7-May-24 20:07 
AnswerRe: Vb6 and sqlserver 2000 Pin
Richard Deeming7-May-24 21:32
mveRichard Deeming7-May-24 21:32 
GeneralRe: Vb6 and sqlserver 2000 Pin
jschell9-May-24 15:35
jschell9-May-24 15:35 
GeneralRe: Vb6 and sqlserver 2000 Pin
Richard Deeming9-May-24 20:58
mveRichard Deeming9-May-24 20:58 
GeneralRe: Vb6 and sqlserver 2000 Pin
jschell11-May-24 9:43
jschell11-May-24 9:43 
GeneralRe: Vb6 and sqlserver 2000 Pin
Victor Nijegorodov11-May-24 21:10
Victor Nijegorodov11-May-24 21:10 
GeneralRe: Vb6 and sqlserver 2000 Pin
Dave Kreskowiak10-May-24 13:31
mveDave Kreskowiak10-May-24 13:31 
GeneralRe: Vb6 and sqlserver 2000 Pin
Richard Deeming12-May-24 21:22
mveRichard Deeming12-May-24 21:22 
GeneralRe: Vb6 and sqlserver 2000 Pin
Dave Kreskowiak13-May-24 3:03
mveDave Kreskowiak13-May-24 3:03 
QuestionSQLite and Firefox Browser 68.0.2 (note: current FFB is now 72.0.2) and what I stand to lose if I update. Pin
RedDk6-May-24 8:56
RedDk6-May-24 8:56 
AnswerRe: SQLite and Firefox Browser 68.0.2 (note: current FFB is now 72.0.2) and what I stand to lose if I update. Pin
Peter_in_27806-May-24 15:18
professionalPeter_in_27806-May-24 15:18 
AnswerRe: SQLite and Firefox Browser 68.0.2 (note: current FFB is now 72.0.2) and what I stand to lose if I update. Pin
Richard Deeming6-May-24 21:44
mveRichard Deeming6-May-24 21:44 
QuestionLooking for a Better Database Solution for Trading Systems Pin
Rene Rose 202120-Apr-24 5:53
Rene Rose 202120-Apr-24 5:53 
AnswerRe: Looking for a Better Database Solution for Trading Systems Pin
Jeremy Falcon20-Apr-24 8:15
professionalJeremy Falcon20-Apr-24 8:15 
AnswerRe: Looking for a Better Database Solution for Trading Systems Pin
RedDk20-Apr-24 8:33
RedDk20-Apr-24 8:33 
AnswerRe: Looking for a Better Database Solution for Trading Systems Pin
jschell23-Apr-24 14:25
jschell23-Apr-24 14:25 
Rene Rose 2021 wrote:
The issue is that the identifier is identical for several hundred thousand data points,


Err...that is not a 'database' problem.

It is a architecture/design problem.

Can you store duplicate rows in a database? Yes.

Should you? That is architecture/design question.

Certainly if the rows are exactly the same then there is no point in storing them. But even in that case you can.

Rene Rose 2021 wrote:
when inserting several hundred thousand data points.


Over what period of time?

One day? Easy. Any database can handle that.

One second? Then yes that is going to be a problem. But even then if that only happens once a day it is not a problem. But if continuous then yes it is a problem.

Lets say it is continuous and you do 100,000 a second and each row is 100 bytes.

Size = (24 * 60 * 60) * 100,000 * 100

If I did the math right then that means you are storing 800 gigs a day.
So if every day then for a year you are going to need a petrabyte of storage for each year. So you might want to check your cloud pricing options before you dive in.

Not to mention that only using 100 bytes of data for one row is very small.
QuestionRun an external program C# from within the Oracle Developer Pin
Member 162354202-Apr-24 10:37
Member 162354202-Apr-24 10:37 
AnswerRe: Run an external program C# from within the Oracle Developer Pin
jschell2-Apr-24 14:18
jschell2-Apr-24 14:18 
QuestionDisplay records based on selected date range in months within same year? Pin
samflex21-Jan-24 9:28
samflex21-Jan-24 9:28 
AnswerRe: Display records based on selected date range in months within same year? Pin
jschell22-Jan-24 5:50
jschell22-Jan-24 5:50 
GeneralRe: Display records based on selected date range in months within same year? Pin
samflex22-Jan-24 8:35
samflex22-Jan-24 8:35 
GeneralRe: Display records based on selected date range in months within same year? Pin
Victor Nijegorodov22-Jan-24 10:10
Victor Nijegorodov22-Jan-24 10:10 

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.