Serverside Processing

manma · March 4

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem: Anybody able to help me to learn

How to use it at server side processing?

Need to know the complete steps from start to end including all scripts.

Any or All helps welcome.

tangerine · March 4

The documentation has a complete working example.
https://datatables.net/examples/server_side/simple.html

allan · March 4

You might also be interested in this blog post which describes how to use the server-side libraries for Editor to do server-side processing.

Or, if you prefer to write your own, the data exchange protocol is documented here.

Allan

manma · March 5

Happily read information from you both.

So far i learned how to use datables with html tables.

Before i continue with my learning on server side processing

needs to know the followings

Is it possible to use txt or csv or data arrays source to use at server side processing ?

If so the maximum number of rows that can be handled with fast loading and without any troubles ?

allan · March 5

In terms of number of rows, see this FAQ.

For server-side processing with txt or csv - you can't just load the files, that would be client-side processing, since the csv / txt file obviously can't perform filtering and ordering itself.

My recommendation - if you have 10k+ rows, import it into an SQL database and use server-side processing. If less, just load the file directly and use client-side processing.

Also, make sure you read this section of the manual so you fully understand the difference between client-side and server-side processing.

Allan

manma · March 5

my knowledge is limited on Datatables but also for other matters.

I am looking to learn to run similar to this at

https://datatables.net/extensions/scroller/examples/initialisation/server-side_processing.html

So to achieve that what are the steps and the scripts required ?

or simply how to achieve that ?

allan · March 5

They are all listed on that page, and you would need server-side processing (i.e. an SQL database, unless you were to write your own for a CSV file).

How many records do you have?

Allan

manma · March 5

just for knowing only.

i would like to take the same number of rows as example at

https://datatables.net/extensions/scroller/examples/initialisation/server-side_processing.html

in the above example the tables is that populated from csv ?

kthorngren · March 5

Its using ajax as a function to generate the simulated row data. The row data is generated in the for loop. The setTiemout function is used to simulate the delay seen when using ajax.

Kevin

manma · March 5

So in the below example link

https://datatables.net/extensions/scroller/examples/initialisation/server-side_processing.html

and in the javascript details as

new DataTable('#example', {
ajax: function (data, callback, settings) {
let out = [];

    for (var i = data.start, ien = data.start + data.length; i < ien; i++) {
        out.push([i + '-1', i + '-2', i + '-3', i + '-4', i + '-5']);
    }

    setTimeout(() => {
        callback({
            draw: data.draw,
            data: out,
            recordsTotal: 5000000,
            recordsFiltered: 5000000
        });
    }, 150);
},
processing: true,
ordering: false,
scroller: true,
scrollY: 200,
searching: false,
serverSide: true

});

So i need to know how the data is placed like

same as in the html file under the above script

or

in a separate data source file ?

kthorngren · March 5

That example is using simulated data to demonstrate the Scroller extension with server side processing. The example does not fetch data from the server. The data is generated, at the client, using the for loop:

        for (var i = data.start, ien = data.start + data.length; i < ien; i++) {
            out.push([i + '-1', i + '-2', i + '-3', i + '-4', i + '-5']);
        }

Which then is populated using the callback function. See the ajax docs for more info about using it as a function. Typically a functoin would need need to be used.

The example is not intended to show how to use server side processing in a production environment.

Kevin

manma · March 6

https://datatables.net/extensions/scroller/examples/initialisation/server-side_processing.html

Anyhow the said example working what ever the environment it belongs to ?

so my intention was to know and asked

how the data is placed like

same as in the html file under the above script

or

in a separate data source file ?

or simply how the data placed and accessed ?

The above asked is to understand the matters which are unknown to me only.

And not get you irritate or make any other situations.

If the matters needs to be back on the screen then keep it as it is.

My intention is pure as TRUTH just like to know and understand it.

manma · March 6

https://datatables.net/extensions/scroller/examples/initialisation/server-side_processing.html

Anyhow the said example working what ever the environment it belongs to ?

so my intention was to know and asked

how the data is placed like

same as in the html file under the above script

or

in a separate data source file ?

or simply how the data placed and accessed ?

The above asked is to understand the matters which are unknown to me only.

And not get you irritate or make any other situations.

If the matters needs to be back on the screen then keep it as it is.

My intention is pure as TRUTH just like to know and understand it.

allan · March 6

The example you link to is only a demonstration of Scroller working with large amounts of data. Use the examples here to see how server-side processing actually works.

Also read the documentation about server-side processing, and if you are using Node.js, PHP, or .NET on the server-side, consider using the server-side processing libraries we provide for Editor.

You cannot perform server-side processing on a raw CSV file! "Server-side processing" means what it says - search, order and paging is done by the server.

Allan

manma · March 16

now i create a web page to learn the server side processing at

http://testlearn.infinityfreeapp.com

but it shows the error as

''DataTables warning: table id=test - Ajax error. For more information about this error, please see https://datatables.net/tn/7''

don't have enough knowledge to rectify it.

any help ?

allan · March 16

Did you follow the instructions in the linked tech note? If you did, you would see that the server is returning a 500 error. That is an internal server error and could be anything from a permissions error in the file system, to the database not running.

Check the server's error logs for any messages to be able to diagnose this issue.

Allan

colin · March 16

Have you followed the steps in the technical notes linked to in the error? That'll be the place to start. If so, what did you find?

Also, the console is showing this error:

Failed to load resource: the server responded with a status of 500 (Internal Server Error)

so you'll need to check the server logs and see what error is happening there.

Colin

manma · March 16

i don't find any error files.

could you able to check it for me ?

https://dash.infinityfree.com/login

username - manmadhang@outlook.com

password - infinityfree*7

kthorngren · March 16

The error is coming from the server. The server logs are what needs to be looked at to debug why the server is returning the 500 internal server error. We won't have access to that by going to the link you provided. Maybe this link will help you with steps to debug:
https://www.siteground.com/kb/internal_server_error_500/#:~:text=When%20you%20encounter%20an%20error,one%20of%20the%20many%205.

Kevin

manma · March 16

i am unable to find it.

that's why provide the access to the server ?

manma · March 16

there is no other files available rather than the said example.

if you can find out then proceed.

no worries.

i grant full access and permission to do so.

kthorngren · March 16

I connected to the page you linked to. There are a lot of options. Please provide the steps needed to see what you want us to look at.

Kevin

manma · March 16

what's the problem that datatable not loading ?

how to rectify it ?

kthorngren · March 16

This is the page I see when logging in. PLEASE provide the steps to see the issue. Where is the Datatable?

Kevin

manma · March 16

click on ''f0_36100839'' next to the green globe image
Website for testlearn.infinityfreeapp.com

it goes to the below page at

https://dash.infinityfree.com/accounts/if0_36100839

from the above page click''control panel'' and open page at

https://cpanel.infinityfree.com/panel/indexpl.php?id=70f054b3e895835c0bc3948a7bec64cde25322b2

from the above page you can go to ''online file manager'' where the web pages available.

also you can access databases by clicking '' phpMyAdmin'' and ''MySQLDatabases''

manma · March 16

or you can access control panel from

https://cpanel.infinityfree.com/panel/index.php

username - removed

password - removed

the above details available on

https://dash.infinityfree.com/accounts/if0_36100839

under ''Account Details''

(click on ''f0_36100839'' next to the green globe image
Website for testlearn.infinityfreeapp.com

it goes to the above page at)

kthorngren · March 16

To solve the 500 server error you will need to look at the server logs. The first link in their tutorials for web sites and PHP is this HTTP 500 error doc:
https://forum.infinityfree.com/docs?topic=49352

Follow the steps there to track down the server errror.

Kevin

manma · March 16

i don't have no knowledge to sort it out.

kthorngren · March 16

Supporting your server environment is out of scope for free community support on this forum. The forum is for Datatables specific questions. You can contact Allan to see if he is willing to help through purchasing a support package. Or perhaps use the infinityfree support forum to get help.

Kevin

allan · March 16

Posting your cpanel login on a public forum is a very bad idea! I've removed the login details. I would strongly suggest you change your password.

As Kevin says, I'd be happy to take a look at the issue under the support packages that I offer. The free support I can offer does not extend to logging in and debugging your server. If that is beyond your own ability you either need to learn those skills or hire a developer to do it for you.

Allan

manma · March 18

I THINK NO HUMANS PAID FOR THE AIR, WATER, SUN AND EARTH they using ?

Posting your cpanel login on a public forum is a very bad idea!

if i think so i will never give it.

i don't think so as you said.

Truth Good Beautiful.

TRUTH ALONE TRIUMPHS
ALWAYS & EVER.

Serverside Processing

Serverside Processing

Answers

Howdy, Stranger!

Categories

DataTables

Serverside Processing

Serverside Processing

Answers

Howdy, Stranger!

Quick Links

Categories

DataTables