Nop with large product database

I work with over 500,000 products.  As soon as I loaded my data into NOP for testing it died.  Clearly it was not desiged to manage a large product database.

Has anyone fixed the paging and queries to solve this problem?

Is there a plan to fix it?

Other than this fatal flaw, it seems to a be a nice framework.

alindzon wrote:
Check:
https://www.nopcommerce.com/boards/t/7518/nopcommerce-performance-with-thousands-of-products.aspx
https://www.nopcommerce.com/boards/t/8379/nopcommerce-18-vs-19-performance-comparison-for-large-stores.aspx
https://www.nopcommerce.com/boards/t/4395/slow-page-loads.aspx?p=4

alindzon wrote:

i had the same problem when i went over 100k products.

I switched to an alternative (paid) solution which claims to support over 1 million products with no problems was only 800 bucks. Certainly we now have 450k on our development one with no problems. I hope nop sorts this out. The new software comes with a free tool to import data that supports being run from a batch file - very useful as we've vast quantities of products to import from around 16 different sources.

I successfully imported a little bit over 10,000 products. there is problem when i add products to category.

CATALOG ------ categories----products-----add products---- add products category ( only shows 1000 products
in search windows) .

How to modify from 1000 products to over 10,000 ? Any suggestion ? Thanks for help.