FORUMS PROFESSIONNELS
WINDEV
,
WEBDEV
et
WINDEV Mobile
Accueil
|
Messages récents
|
Connexion
|
Déconnexion
|
Français
Accueil
→
WINDEV 2024
→
sql server table with 100 to 200 columns
sql server table with 100 to 200 columns
Débuté par ccc2, 03 mai 2018 18:05 - 4 réponses
Connectez-vous…
ccc2
#1
Posté le 03 mai 2018 - 18:05
First time I see a program where database contain tables where each table has 100 to 200 columns .
my question
1. is this normal ?
2. will making more columns give better performance ? than more tables?
Signaler
0
0
InfosPilot
#2
Posté le 03 mai 2018 - 18:36
Hi
It's always better to have more tables that are linked to the keys
Signaler
0
0
Paulo Oliveira
#3
Posté le 03 mai 2018 - 19:10
If you use select * or hread??? functions you will read all the columns and probably you only need some of them, the network traffic is huge without any need.
If you use queries and only get the columns you need it's not a major problem if your indexes are well defined.
Signaler
0
0
DerekT
#4
Posté le 04 mai 2018 - 21:30
Quote
Paulo Oliveira
If you use select * or hread??? functions you will read all the columns and probably you only need some of them, the network traffic is huge without any need.
If you use queries and only get the columns you need it's not a major problem if your indexes are well defined.
Thats essentially correct but on a table with 200 columns the number of indexes could well be 50+
This will cause a serious overhead when CRUD operations are performed.
Of course this could come from a 'Big Data' type DB where, I'm led to believe, anything goes pretty much.
Signaler
0
0
ccc2
#5
Posté le 08 mai 2018 - 13:45
Hi DerekT,
Not Big Data, just normal MS SQL . if you familiar with "EXACT" , take a look at the DB , many of tables contain more than 100 columns . if that not make complicate, the table, columns and fields name not in english :rp:
I notice one advantage of having all in one table , locking record become easy.
Signaler
0
0
→ Revenir à WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (précédentes versions)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Type de recherche
Uniquement les sujets
Tous les messages
Période de recherche
Date indifférente
Moins d'une heure
Moins de 24 heures
Moins d'une semaine
Moins d'un mois
Moins d'un an
Annuler
Aperçu de votre message
Ajouter une image
Importer une image depuis une URL
Envoyer une image depuis un fichier de votre disque
Déposez ici un fichier ou cliquez sur "Parcourir..."
ou
Annuler
0%
WLangage
SQL
XML, HTML
JAVA, Javascript
Texte