Help Ekak One ! SQL Query Help !

[Chandi_Bandi]

Machanla mysqli result query ekakin data 3000 k withara table ekakin load karanna one. man array ekakin datatable ekakata load kranne. mysqli select query ekath specific coloums witharai select karanne. eth load weddi patta slow ne. speed kara ganna mokakda karanna puluwan ??
Host eka use karanne - Namecheap ( steller Plus )

 

[dilw]

Paging karahan

 

[Chandi_Bandi]

Paging karahan

machan poddak explain karanna puluwanda ? link ekak hari kamak nha.

 

[Enigmakluse]

අප්

 

[KandyMalli]

tabl desc

Gahala ena tika dapn ko.

 

[Chandi_Bandi]

tabl desc

Gahala ena tika dapn ko.

okkoma load karanna one macn. query eka desc dala thiyenne.

 

[dilw]

machan poddak explain karanna puluwanda ? link ekak hari kamak nha.

uba karana language eka auwa wenas wenawa bn, DB eken eka sare okkoma load karanne nathuwa data 10 10 wage kali walata kadala pages widihata ganna eka thama karanne

https://www.aspsnippets.com/Article...ide-Paging-and-Sorting-using-jQuery-AJAX.aspx

 

[KandyMalli]

okkoma load karanna one macn. query eka desc dala thiyenne.

Db table structure eka gena kiwwe mcn

 

[kavindagk]

Ajax walin data load karanne ethakota poddak shape karaganne puluwan

https://stackoverflow.com/questions/14198316/best-way-to-show-large-amount-of-data/14198507

 

[hodakolla]

BUMPER

 

[NRTG]

BUMP

 

[adowhybn]

BUMP