Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What do you do with the star data? If you only look at data for one category at any given time this might work, but it is hard to maintain. Every time you have a new category, you will have to build a new table. If you want to query across categories, it becomes more complex and possibly more expensive in terms of time. If you do this and do want to query across categories a view is probably best (but do not pile views on top of views). If you are looking for data on a particular star, would you know which table to query? If not then how are you going to determine which table or are you goign to query them all? When entering data, how will the application decide which table to put the data into? How many categories will there be? And incidentally relating to each having a separate id, use the bigint identities and combine the identity with the category type for your unique identifier.</p> <p>Truly do you need to delete the whole category or only the star that the data changed for? And do you need to delete at all, maybe you only need to update information. </p> <p>Have you tried deleting in batches (1000 records or so at a time in a loop). This is often much faster than deleting a million records in one delete statement. It often keeps the table from getting locked during the delete as well. </p> <p>Another technique is mark the record for deletion. Then you can run a batch process when usage is low to delete those records and your queries can run on a view that excludes the records marked for deletion. </p> <p>Given your answers, I think your proposal may be reasonable. </p>
    singulars
    1. This table or related slice is empty.
    1. POSQL Server Efficiently dropping a group of rows with millions and millions of rows
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USHLGEM
    1. USHLGEM
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. CODo you ever have to query across star categories? I never have to query across star categories.
      singulars
      1. PO
      1. USNet Citizen
    2. COIf you are looking for data on a particular star, would you know which table to query? Yes
      singulars
      1. PO
      1. USNet Citizen
    3. COWhen entering data, how will the application decide which table to put the data into? The insertion of star data is done all at once at the start when the categoryId is created.
      singulars
      1. PO
      1. USNet Citizen
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload