Highlighted

tips for speed up to show million records from DB

Community Beginner ,
Jul 11, 2014

Copy link to clipboard

Copied

Please let me know the tips for  speed up application ....

Our application need to show million records from database its taking time to load ...

Thanks in advance

Bibin

Saving html in your DB isn't going to speed anything up... you'll still end up having to render 1000000 table rows to the client.

Ditch Bootstrap pagination, it's purely client side.  Your page size must be huge.  Do it server side so you can request and render just 100 (for example) rows at a time.  Alternatively combine with Bootstrap to make ajax requests for each page in response to user clicks.

Views

255

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

tips for speed up to show million records from DB

Community Beginner ,
Jul 11, 2014

Copy link to clipboard

Copied

Please let me know the tips for  speed up application ....

Our application need to show million records from database its taking time to load ...

Thanks in advance

Bibin

Saving html in your DB isn't going to speed anything up... you'll still end up having to render 1000000 table rows to the client.

Ditch Bootstrap pagination, it's purely client side.  Your page size must be huge.  Do it server side so you can request and render just 100 (for example) rows at a time.  Alternatively combine with Bootstrap to make ajax requests for each page in response to user clicks.

Views

256

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Jul 11, 2014 1
Engaged ,
Jul 11, 2014

Copy link to clipboard

Copied

A million records will take a long time to display.  Try paginating them instead.  This then means you also don't need query to get all records at once, you can get X records at a time.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 11, 2014 0
Community Beginner ,
Jul 11, 2014

Copy link to clipboard

Copied

Already have bootstrap pagination but that apply once all records load

  Can i able to save entire  <tr><td>prj1 </td></tr>  in db colum ?

a schedule task for save records in a new table

<cfsave content  var ='test'><tr><td>#prj1#</td><td><img > </td><td>#proj dec# </td></tr></cfsavecontent>

insert into new_table (colum1)

value(test);

so that will save all ( include image and all)  in TR result in 1 colum and disply this

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 11, 2014 0
Engaged ,
Jul 11, 2014

Copy link to clipboard

Copied

Saving html in your DB isn't going to speed anything up... you'll still end up having to render 1000000 table rows to the client.

Ditch Bootstrap pagination, it's purely client side.  Your page size must be huge.  Do it server side so you can request and render just 100 (for example) rows at a time.  Alternatively combine with Bootstrap to make ajax requests for each page in response to user clicks.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 11, 2014 1
Adobe Community Professional ,
Jul 11, 2014

Copy link to clipboard

Copied

A million records, huh? Common database brands can handle that. To improve performance,

1) Critically question the use-case to find out whether a smaller number of records will do;

2) Cache reusable static data on the Coldfusion server, so that you wouldn't have to load it every time;

3) Load just the data columns that are absolutely necessary;

4) Use indices.

What is your database type?

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Jul 11, 2014 0