This is now just hypothesis BUT problem could be the fact that jQuery can't handle such a big amount of data based on this blog post: gabrieleromanato.name/the-limits-of-jquery-with-large-data-structures/ (I can't post links so removed http part from the beginning) it is said that jQuery crashes when example code described in this blog creates table with 30000 rows and 90000 table cells. And for fetching all your products from the databases jQuery has to create a table that has 70000 rows (even if it uses pagination to divide received data on multiple pages it will fetch all data from your db and how big amount of data it for once dumbs into a table showed on your openERP client depends on the implementation).

But like I said this is just hypothesis that you could use for trying to find solution from google I can't be 100% sure if this is connected to your problem.

Edit: out of curiousity could you test to import your products to runbot and check if it will have the same problem (other alternative if you don't want to put your data to runbot is that you download this 15 days trial if you haven't used it yet and test to import data there)? Then we would know if problem is in your configuration/system or in OpenERP in general.

Restart your server with the --debug option and see what the log says. You will have detailed information of what caused the crash

I tried this fix and works very well. h_t_t_p_s://code.launchpad.net/~openerp-dev/openerp-web/6.1-opw-574218-xal/+merge/10737

In the UI, there is absolutely no point in fetching all the records, when a user is only interested in finding a handful of them (see @Laura Jarvenpaa's reply on how JS handles it).

You could jump directly to /addons/web/static/src/js/view_form.js:2937 in your server and specify the limit explicitly:

--- addons/web/static/src/js/view_form.js   2013-10-10 09:11:25 +0000
+++ addons/web/static/src/js/view_form.js   2013-12-11 12:09:11 +0000
@@ -2934,7 +2934,7 @@
 values.push({
     label: _t("Search More..."),
     action: function() {
-        dataset.name_search(search_val, self.build_domain(), 'ilike', false).done(function(data) {
+        dataset.name_search(search_val, self.build_domain(), 'ilike', 500).done(function(data) {
             self._search_create_popup("search", data);
         });
     },

A limit of 500 records is more than enough for manual handling - and UI is exactly for this, it's not a batch processing of db data or something.

If you also use web_m2o_enhanced module, then the very same change will have to be introduced to the dataset.name_search() function invocation in web_m2o_enhanced/static/src/js/form.js (search for 'Search More...' in the file).

Hello, Maybe you could start by taking a look at the openerp-server.log file You should find some useful informations in there.

Regards.