Kategoria:Database

From Dokumentacje GRYFsoft

Rules on database

Almost whole logics of application are on clients. Also system is quite hermetic thanks to database permissions system. We need maximal optimalisation of questies so we use some rules:

  • Try not to use primary or unique keys.
  • Do not use foreign keys.
  • Use indexes on often searched fields.
  • Try not to use triggers.
  • Try not to do much joins.
  • Don't use views.

Podkategorie

Jest jedna podkategoria

C

Artykuły w kategorii "Database"

Liczba artykułów w tej kategorii: 9

C

T

T c.d.

T c.d.