Advanced Screener Update Speed and Saving More Than 100 rows to Excel

Hello,

Just wanted to thank you in advance for a great site.

I was wondering if there are any plans to decrease the time it takes to load the advanced screener after applying the filters? It's taking me >30 seconds to update the page each time...

Second request: Can you increase the number of rows I can export to excel? I'm limited to 100 rows.

Thanks!

Submitted by GrahamGraham. Created on Friday 28th October 2022. Updated on Friday 28th October 2022.

Submitted by GrahamValue on Saturday 29th October 2022

Dear Investor,

Thank you for your forum post!

A page traverse of the Advanced Graham Screener with all Public-Utilities and Financial Enterprises filters selected does not appear to currently take more than 6-7 seconds. Could the delay you're facing be due to network or browser issues? The page load can be delayed if the network is slow, or if the browser has too many tabs open.

The current View and Export limit of 100 Rows on the Advanced Graham Screener is by design. The Advanced Graham Screener does extensive database querying on every request. Note that the Classic Graham Screener only takes 1-2 seconds for a similar page traverse with all filters selected. The limits are therefore set to manage the database load on the server, as well as the display load on the browser.

Thank you again for your forum post!

Submitted by GrahamValue on Saturday 3rd December 2022

Dear Investor,

Thank you for your forum post!

Certain types of Search Keywords can also cause the screeners to respond slower than usual. For example, negative search terms such as "-ADR" etc.

However, this only happens when the Search Keywords field on the screeners is used; and not on the regular Graham Analysis Search.

Thank you again for your forum post!

Submitted by GrahamValue on Monday 12th December 2022

Dear Investor,

Thank you for your forum post!

Certain types of screener queries can also be slower when the database is undergoing a full update. Again, this is temporary and the queries should revert to a more normal response time once the update has completed.

Also, please note that the Excel Export is simply a client-side script that copies the contents of the displayed page to a file. There is no data sent from the server for the export. This is the reason the export is instantaneous.

So the export size is essentially limited by the display size.

Thank you again for your forum post!