Click here to Skip to main content
15,120,567 members

Welcome to the Lounge

   

For discussing anything related to a software developer's life but is not for programming questions. Got a programming question?

The Lounge is rated Safe For Work. If you're about to post something inappropriate for a shared office environment, then don't post it. No ads, no abuse, and no programming questions. Trolling, (political, climate, religious or whatever) will result in your account being removed.

 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
5teveH28-Aug-21 4:58
Member5teveH28-Aug-21 4:58 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
Sander Rossel28-Aug-21 0:56
professionalSander Rossel28-Aug-21 0:56 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
5teveH28-Aug-21 4:02
Member5teveH28-Aug-21 4:02 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
Member 798912228-Aug-21 5:54
MemberMember 798912228-Aug-21 5:54 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
Gerry Schmitz28-Aug-21 5:47
mveGerry Schmitz28-Aug-21 5:47 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
englebart28-Aug-21 6:04
professionalenglebart28-Aug-21 6:04 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
Eddy Vluggen28-Aug-21 9:56
professionalEddy Vluggen28-Aug-21 9:56 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
5teveH29-Aug-21 21:56
Member5teveH29-Aug-21 21:56 
Eddy Vluggen wrote:
Indexing data HAS a performance hit
True. I was responding to a comment about indexing variable length data having a much bigger performance hit - and that was not at all clear. Yes, I totally accept that everything you do on a system is going to take some resource - including indexing data. But, certainly on the database I work with, (which is completely variable length), there is no 'real world' impact when you index data. Which, I don't think is surprising. If you design a database from the ground up, to be variable length, you are going to deal with things like indexing variable length data as the rule, rather than the exception.
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
Eddy Vluggen30-Aug-21 16:42
professionalEddy Vluggen30-Aug-21 16:42 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
Asday30-Aug-21 7:56
MemberAsday30-Aug-21 7:56 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! - Part II Pin
jschell5-Sep-21 9:31
Memberjschell5-Sep-21 9:31 
GeneralThought of the Day Pin
OriginalGriff27-Aug-21 5:09
mveOriginalGriff27-Aug-21 5:09 
GeneralRe: Thought of the Day Pin
Mike Hankey27-Aug-21 5:59
professionalMike Hankey27-Aug-21 5:59 
GeneralRe: Thought of the Day Pin
Kschuler27-Aug-21 6:01
MemberKschuler27-Aug-21 6:01 
GeneralRe: Thought of the Day Pin
User 991608027-Aug-21 6:10
professionalUser 991608027-Aug-21 6:10 
GeneralRe: Thought of the Day Pin
jeron127-Aug-21 6:26
Memberjeron127-Aug-21 6:26 
GeneralRe: Thought of the Day Pin
Slacker00727-Aug-21 7:02
professionalSlacker00727-Aug-21 7:02 
GeneralRe: Thought of the Day Pin
Member 1532961327-Aug-21 7:24
MemberMember 1532961327-Aug-21 7:24 
GeneralRe: Thought of the Day Pin
DRHuff27-Aug-21 9:04
MemberDRHuff27-Aug-21 9:04 
GeneralRe: Thought of the Day Pin
Eddy Vluggen27-Aug-21 17:07
professionalEddy Vluggen27-Aug-21 17:07 
GeneralImposing data type and length restrictions at the database level is stupid! Pin
5teveH27-Aug-21 3:26
Member5teveH27-Aug-21 3:26 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
Richard Deeming27-Aug-21 3:36
mveRichard Deeming27-Aug-21 3:36 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
5teveH27-Aug-21 4:02
Member5teveH27-Aug-21 4:02 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
obermd27-Aug-21 4:39
Memberobermd27-Aug-21 4:39 
GeneralRe: Imposing data type and length restrictions at the database level is stupid! Pin
RickZeeland27-Aug-21 3:43
mveRickZeeland27-Aug-21 3:43 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.