Hellow

how large the database supports this Module (i need about 1000 rows and 10 columns)?

Greetings

Hello,

The module supports sever side pagination for data from a database so it is possible to use the module with large databases.

Regards,
ARI Soft

I use it with more than 10.000 records...

www.on7rk.be/nl/lb.html

Ken

Hi,

I want to display up to 25,000 data from my database. Without server side pagination, I get a blank page. With the server side pagination, the search is not working and I have a message that there is no record, which is not the case.

1. How do you configure the art data table module for a large amount of data?
2. My sql query is joining several tables. Would it be better if I first normalize the results in one table?

Thanks in advance.

Hello,

1. If "Server side pagination" is disabled, all data will be loaded on a page. 25k is a lot of records and memory limit will be exhausted on server side. Could you specify what SQL query do you use?

2. You can use "JOIN" constructions without problem.

Regards,
ARI Soft

Hello,

Thank you for your quick reply.

This is my query:

SELECT b.job_title, c.type, CONCAT(a.first_name,' ',a.last_name) full_name, a.email, a.tel, CONCAT('<a href=www.jobinrwanda.com/',a.file_hash,'_',a.filename, '>','Download','</a>' ) as CV FROM dy849_jobboard_applicants a, dy849_jobboard_jobs b, dy849_jobboard_categories c WHERE 1=1 AND a.job_id = b.id AND b.category=c.id

Regards,

Jim-