• Global community
    • Language:
      • Deutsch
      • English
      • EspaƱol
      • FranƧais
      • PortuguĆŖs
  • ę—„ęœ¬čŖžć‚³ćƒŸćƒ„ćƒ‹ćƒ†ć‚£
    Dedicated community for Japanese speakers
  • ķ•œźµ­ ģ»¤ė®¤ė‹ˆķ‹°
    Dedicated community for Korean speakers
Exit
1

tips for speed up to show million records from DB

Community Beginner ,
Jul 11, 2014 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

Views

329

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
community guidelines

correct answers 1 Correct answer

Engaged , Jul 11, 2014 Jul 11, 2014

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.

Votes

Translate

Translate
Engaged ,
Jul 11, 2014 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.

Votes

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
community guidelines
Community Beginner ,
Jul 11, 2014 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

Votes

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
community guidelines
Engaged ,
Jul 11, 2014 Jul 11, 2014

Copy link to clipboard

Copied

LATEST

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.

Votes

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
community guidelines
Community Expert ,
Jul 11, 2014 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?

Votes

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
community guidelines
Resources
Documentation