Database weddo warella

[3rd_Eye]

Machan la mata podi prashnayak thiyanawa. Poddak uttara diyalla. Ebay wage web site ekaka kohomada machan items thiyagena inne. Eka eka category walata table use karoth api search query eka liyaddi mona table eken da data ganne kiyana eka decided karanne kohomada. Machan danna kenek pahadili karanna

 

[Don Udugama]

danne na bn
bump

 

[The_Killer]

SELECT * FROM items WHERE item_name = "watch"

Basic idea ekak enawa ne? Okkoma thiyenne items kiyala table ekaka. Eken thamai populate karala pennanne.

 

[powers]

danne na bn
bump

 

[3rd_Eye]

SELECT * FROM items WHERE item_name = "watch"

Basic idea ekak enawa ne? Okkoma thiyenne items kiyala table ekaka. Eken thamai populate karala pennanne.

Okkoma items eka table ekaka thibboth patta slow machan search ekedi
Records 50 million wage thibboth 15 min Wath yai search wenna index wenne item name varchar nisa index eken wedak wenne na.

 

[3rd_Eye]

bump

Thanks

 

[3rd_Eye]

danne na bn
bump

Thanks machan

 

[The_Killer]

Okkoma items eka table ekaka thibboth patta slow machan search ekedi
Records 50 million wage thibboth 15 min Wath yai search wenna index wenne item name varchar nisa index eken wedak wenne na.

Normal MySQL slow nam, NOSQL or Oracle DB use karanna ona eka thamai machan. Ape un basic MySQL dagena hariyata server optimize nokara (buffer pool, table cache sizing) db slow, query slow ganawa.

 

[topkollek]

Okkoma items eka table ekaka thibboth patta slow machan search ekedi
Records 50 million wage thibboth 15 min Wath yai search wenna index wenne item name varchar nisa index eken wedak wenne na.

"Full text search" ahala nedda?

 

[The_Killer]

Records 50 million gana katha karanna kalin items 10,000k wath daganna epai DB ekata. passe passe slow nam normalize and optimize karanawa. Muhuda hath gowwak thiyeddi amuda gahanawa kiyanne oka thamai.

 

[3rd_Eye]

Normal MySQL slow nam, NOSQL or Oracle DB use karanna ona eka thamai machan. Ape un basic MySQL dagena hariyata server optimize nokara (buffer pool, table cache sizing) db slow, query slow ganawa.

E kiyanne machan ebay amazon wage site wala items thiyagena inne eka table ekakada. Mmm ela ela mata sahana kalaeka indala thiyana prashnayak ban. Mongodb wage db use karanawa athi. Eka thamai rahasa. Ela ela thanks machan.

 

[M@D$]

E kiyanne machan ebay amazon wage site wala items thiyagena inne eka table ekakada. Mmm ela ela mata sahana kalaeka indala thiyana prashnayak ban. Mongodb wage db use karanawa athi. Eka thamai rahasa. Ela ela thanks machan.

oba hari suggestions speed up karannath eka thama use karanne..
https://dzone.com/articles/ebay-secret-database-scaling

 

[The_Killer]

E kiyanne machan ebay amazon wage site wala items thiyagena inne eka table ekakada. Mmm ela ela mata sahana kalaeka indala thiyana prashnayak ban. Mongodb wage db use karanawa athi. Eka thamai rahasa. Ela ela thanks machan.

Imagination is your limit machan. Onanam item name wise A-Z table hadan ewala store karaganna. Onanam item name walata 1 table ekak use karanna. records UNIQUE items 100,000k wath nathnam worry wenna epa echchara db slow gana. DB slow newei query+programming part ekai slow wenne.

 

[TheNewThinker]

Slow na ban ewta wada tiyenwa. Umba mysql da use kranne.

 

[chathuranga8887]

ENTITY
*Product_category(ID,Category_Name)
*Product_Master(ID,Product_name,Category_ID)
*Product_Tag(Product_ID,TAG) Eg:tag(comma separate)

Using this kind of tables
using product name
*Select * from Product_Master where Product_name like '%<Search Word>%'

Using product category
*select * from product_master pr,Product_category pc
Where pr.Category_ID=pc.ID
and pc.Category_Name like '%<Search Word>%'

Using Tag
select * from product_master pr,Product_category pc,Product_Tag pt
Where pr.Category_ID=pc.ID
AND pr.ID=pt.Product_ID
and pt.TAG like '%<Search Word>%'

මේක මචන් simple විදියට ලිවේ ඖලක් තියේනම් PM කරනන

 

[3rd_Eye]

oba hari suggestions speed up karannath eka thama use karanne..
https://dzone.com/articles/ebay-secret-database-scaling

Elaz thanks machan

 

[3rd_Eye]

Imagination is your limit machan. Onanam item name wise A-Z table hadan ewala store karaganna. Onanam item name walata 1 table ekak use karanna. records UNIQUE items 100,000k wath nathnam worry wenna epa echchara db slow gana. DB slow newei query+programming part ekai slow wenne.

Ela ela thanks macho

 

[3rd_Eye]

Slow na ban ewta wada tiyenwa. Umba mysql da use kranne.

App ekak hadanna neme nikan Dana ganna ban ahuwe mage oluwe thibba prashnayak

 

[3rd_Eye]

ENTITY
*Product_category(ID,Category_Name)
*Product_Master(ID,Product_name,Category_ID)
*Product_Tag(Product_ID,TAG) Eg:tag(comma separate)

Using this kind of tables
using product name
*Select * from Product_Master where Product_name like '%<Search Word>%'

Using product category
*select * from product_master pr,Product_category pc
Where pr.Category_ID=pc.ID
and pc.Category_Name like '%<Search Word>%'

Using Tag
select * from product_master pr,Product_category pc,Product_Tag pt
Where pr.Category_ID=pc.ID
AND pr.ID=pt.Product_ID
and pt.TAG like '%<Search Word>%'

මේක මචන් simple විදියට ලිවේ ඖලක් තියේනම් PM කරනන

Ela ela thanks machan tag walin allana puluwan. Mama hithuweth oya widiya. Mata danaganna ona kale mokak da standard widiya kiyala thanks macho

 

[3rd_Eye]

"Full text search" ahala nedda?

Na machan Google karala balannam thanks macho