What is the performance of virtuemart 4 compared to virtuemart 3.8.7? I have 500,000 products. Has sql performance improved? Do you recommend switching to it ?
I am very sure that it is faster than before. There are some more caches, fixed and enhanced caches, better db layout. A benchmark would be very interesting.
when virtuemart 4 stable will be realesed ?
It is stable for j3, but not j4 (But from my point of view, the reason is more to find in j4). Just try the last https://dev.virtuemart.net/attachments/1335/com_virtuemart.4.0.7.10718_package_or_extract.zip
From my point of the view the most stable version. I just wait or more tests. But almost any answer is for j4 or PHP8.1 and some for PHP8.0.
That is the problem currently, what means stable? VM4 with j3 and with php7.4 works pretty stable since vm4.0.0. But there are also enhancements for that combination. So it is hard to say. The worst combination would be vm4, j4 and php8.1 Most of the PHP8 problems are solved, there are a lot shops running with PHP8.0 and have no problems. I dont know the number, but lets say at least 50. Could also be hundreds. This is estimated by reports of different webagencies/webdevelopers.
But it just depends what people are using. It is hard to estimate any use case and to test any combinations. It happens that people used "impossible" configurations, but it was correct.
So as long you use j3 and PHP7, you should be absolutly fine with the vm4.0.7, for testing. Currently I plan the release of vm4.0.8 for this week. Focus is on j3/php7.4 combination, which is the important configuration for most users.
JInstaller: :Install: Не уSPAMалось найти XML-файл SPAMля установки пакета.
Duplicate entry '5' for key 'PRIMARY'
VirtueMart Package cant be removed from extensions
virtuemart 3-4 tools mysql very sux. cant migrate , cant update, cant remove tables, boolsheet
my site is dead after install 4 latest VM. testes 500 000 products on VDS. sql db dead
I wrote a pm to you, for extra support.
Quote from: 2dmaster on October 11, 2022, 13:23:40 PM
JInstaller: :Install: Не уSPAMалось найти XML-файл SPAMля установки пакета.
Duplicate entry '5' for key 'PRIMARY'
Could not find xml? The package worked for 91 downloads so far and no one complained about this problem. This must be something else. You may extract the package and install the components one by one, first the core, then the AIO, then the rest.
Duplicated entry 5 for key primary? Without the table hard to say why it happens. But also here, no one else had that problem so far. But I had a customer some weeks ago with a really "old" store (maybe like yours), but up to date (like yours), but the db had some obstacles in it. Which happend years ago.
When I know the table regarding this error, then I am sure I can fix it very fast. Just answer my PM, please.
Quote from: 2dmaster on October 11, 2022, 13:47:27 PM
virtuemart 3-4 tools mysql very sux. cant migrate , cant update, cant remove tables, boolsheet
I am sorry for this experience, but you have really a big load of products. In this case it is very important that you set for the installation process the RAM and Max Exec time to "Maximum". 2 GB, 30 minutes, for example, or even 60 minutes.
You can test system sql tools install vm387, install 4, , install 387 again
Or install 387, run tools, install 4 run tools, install 387 again
Its backward compability
Allproblems with development you testing old apache not litespeed , but its easy,
And you not test upgrade, reinstall, uninstall all versions of virtuemart, package, modules, and vm tools.
I understand why shop of 387 dead after upgrade to virtuemart 4 platform.
Pls dear friend can you test it with 500k products ? Gzip off anywhere
tried to install the version again without uninstall ?
Jörgen
Quote from: Milbo on October 10, 2022, 12:09:31 PM
better db layout.
If you update a big shop you must take more care than a shop with 100 products. In special changes of the db layout. VM4 has a lot more keys for faster joins and search. But if you have a lot products, customfields and so on, then that can take a lot time for the db to reorganise. Remember the window must kept open for the update as long it takes.
It is no problem to update a small store while it is live, 1-2 visitors are not a problem. The catalogue mode during the installation is enough (it prevents writes to the tables). But if you have a big store and you have a lot customers, then you must set the shop offline, at best the whole joomla page, or the access to the shop at least. Then set the max RAM and max execution time in php to your Maximum. As written before at least 2GB RAM and 60 minutes.
Then extract the package and install the containing installers one by one. First the core, then the AIO, then the admin template (vmadmin.zip), then the TcPDF.
To avoid problems, check that your orderstati character (P,U,C,S,X,...) are unique! You can also use "Optimise tables" before the update.
Quote from: 2dmaster on October 18, 2022, 19:26:07 PM
I INSTALLED JOOMLA 4.2.3 for testing and TRY TO INSTALL com_virtuemart.4.0.7.10720.zip.
cant install VM ::
Table 'db_dbvm4.jilx_virtuemart_configs' doesn't exist
Пакет: Установка: В процессе установки произошла ошибка: com_virtuemart.4.0.7.10720.zip.
This sounds really shitty. I fear the server stopped during reorganising the tables. So you should use the sql REPAIR on them first.
Man, i said , its a new test of joomla 4 and virtuemart 4,. CLEAN Install not work with this db error, joomla 4 boolshit, and vm 4 not work
QuoteI INSTALLED JOOMLA 4.2.3 for testing and TRY TO INSTALL com_virtuemart.4.0.7.10720.zip.
Yep, I instaled the same and all function perfect:
joomla4.easy.minion.cz
cus