pcsoft.us.windevCopyright 2026, PC SOFT8 May 2018 13:45:00 Z3 May 2018 18:05:00 ZFirst 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?30WEBDEVen_UShttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns/read.awpmoderateur@pcsoft.fr (El moderador)webmaster@pcsoft.fr (El webmaster)guestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65405/read.awp8 May 2018 13:45:00 ZHi DerekT, Not Big Data, just normal MS SQL . if you familiar with "EXACT" , take a look at the DB , many of tables contain m…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65405/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65405/read.awpsql server table with 100 to 200 columnsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65376/read.awp4 May 2018 21:30:00 ZQuote Paulo Oliveira If you use select * or hread??? functions you will read all the columns and probably you only need some…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65376/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65376/read.awpsql server table with 100 to 200 columnsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65370/read.awp3 May 2018 19:10:00 ZIf you use select * or hread??? functions you will read all the columns and probably you only need some of them, the network tra…https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65370/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65370/read.awpsql server table with 100 to 200 columnsguestpcsoft.us.windevhttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65369/read.awp3 May 2018 18:36:00 ZHi It's always better to have more tables that are linked to the keyshttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65369/read.awphttps://forum.pcsoft.fr/es-ES/pcsoft.us.windev/65361-sql-server-table-with-100-200-columns-65369/read.awpsql server table with 100 to 200 columns