I
I
Ivan Karabadzhak2011-11-26 11:58:31
Database
Ivan Karabadzhak, 2011-11-26 11:58:31

The structure of the database for statistics, how to organize?

There is a table in a DB in which records about some objects are stored. My software selects data in batches from this table. That is, the program pulls out 10-15 objects at a time. I need to store statistics about the received packs. I'm thinking of just making 1 more table in the database and let the software write there what it does, for example date, number of objects.
Question: “What is the best way to record which object IDs were received by the program in this batch?”

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
mark_ablov, 2011-11-26
@mark_ablov

It depends what you do with these IDs.
If you want to JOIN, then it's better to make an intermediate table, as everyone does for many-to-many hierarchies.

M
Melkij, 2011-11-26
@melkij

Depends on further actions with these statistics.
In the general case - date, id

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question