It contains over a thousand columns, how can I make it server-processing?
I guess you mean rows.. thus: no users needs thousands of rows in the UI.
Can you rephrase your question, please?
Jazzy 1012
ASKER
No its a report for me to look at all the information, in the database this query is around 2,000 rows so when I run it on the browser it takes time to load the page, I want it to load page by page, I already have datatables but it doesnot load page by page
David Favor
You'll likely hit several problems.
1) You're using <table> to display your data, which I'd say is correct, as it's table data.
2) Without seeing your CSS, it's unclear how fast your <table> will render. If you set hard coded widths or screen percentages, your table will display fairly quickly, because the table can be rendered one row at a time.
Without this type of CSS, your table can only render after all the data is downloaded.
3) Your speed is also dependent on your database tuning + storage engine + maybe /tmp location (disk or tmpfs/memory).
4) Your speed is also dependent on your connection speed, if this will be viewed on mobile devices on slow networks.
Many things to consider.
If you have a large development budget, hire someone to audit your hosting + code to ensure every layer is tuned optimally.
If this is a personal project... start by tuning your hosting, till you can sustain very fast page renders with an empty table, then move onto optimizing your data transfer.
Can you rephrase your question, please?