Database Table

[AnuradhaRa]

first name, second name කියල දාන්නෙ නැතුව
සම්පූර්ණ නම එක field එකකට දැම්මොත්, පුද්ගලයින්ගෙ නම් parially match වෙන්ඩ කෝඩ් ලියන්ඩ බැරිද?

උදා
Saman Perera
Akila Perera

Perera කියල දුන්නම ඔය නම් දෙකම එන්ඩෝන

 

[dilshangwn]

puluwan... where LIKE kiala google karanna

habai mage adahasa nam ehema use case tiyenawa kianne first name last name wenama danna one

 

[chinmak]

first name, second name කියල දාන්නෙ නැතුව
සම්පූර්ණ නම එක field එකකට දැම්මොත්, පුද්ගලයින්ගෙ නම් parially match වෙන්ඩ කෝඩ් ලියන්ඩ බැරිද?

උදා
Saman Perera
Akila Perera

Perera කියල දුන්නම ඔය නම් දෙකම එන්ඩෝන

Ammapa mata hitaganna bari uba me athal ekakda ganne kiyala

 

[AnuradhaRa]

Ammapa mata hitaganna bari uba me athal ekakda ganne kiyala

බොරුවක් නෙමේ බං

 

[AnuradhaRa]

puluwan... where LIKE kiala google karanna

habai mage adahasa nam ehema use case tiyenawa kianne first name last name wenama danna one

ඒක තමා මාත් බැලුවෙ

 

[kosandpol]

first name, second name කියල දාන්නෙ නැතුව
සම්පූර්ණ නම එක field එකකට දැම්මොත්, පුද්ගලයින්ගෙ නම් parially match වෙන්ඩ කෝඩ් ලියන්ඩ බැරිද?

උදා
Saman Perera
Akila Perera

Perera කියල දුන්නම ඔය නම් දෙකම එන්ඩෝන

puluwan... where LIKE kiala google karanna

habai mage adahasa nam ehema use case tiyenawa kianne first name last name wenama danna one

this is not an optimized solution. The name field will be a large text field taking up a lot of space as the DB grows and it will take up a lot of memory to search as well as the DB grows.
This is why the name is stored in several fields.

 

[hasithayad]

select full_name from table where full_name like '%perera%'

 

[AnuradhaRa]

select full_name from table where full_name like '%perera%'

එහෙම වැඩ කරන්නෙ නෑ බං

 

[AnuradhaRa]

this is not an optimized solution. The name field will be a large text field taking up a lot of space as the DB grows and it will take up a lot of memory to search as well as the DB grows.
This is why the name is stored in several fields.

 

[dilshangwn]

this is not an optimized solution. The name field will be a large text field taking up a lot of space as the DB grows and it will take up a lot of memory to search as well as the DB grows.
This is why the name is stored in several fields.

Not true. A typical name and an email address usually take up the same space. Also things like order notes etc. Product Names...

And database engines have other mechanisms for searching.

We store names in different columns because there are use cases for it ... not because its gonna take more space to store in a single column

 

[MihiCherub]

epa.. single column thiyapan. api ubala me loke allanna app liyanne nane.. loke allanna puluwan unath eda remodule karanna puluwan.



thani column eke thiyapan. DB Normalization amathakama karapan. ewa me column 100-200 thiyena table 1000+ DB walata misak column 5-6 table 20k thiyenawa DB walata neme.