Hello,
I tested Midgard with more than 800000 articles.
First I checked the code, no compilation to do.
Second I modified the 2 columns article.id and article.up
from smallint to integer.
The box
Pentium III 450 with 128 Mb of memory running RedHat 6.0
Inserting articles
This will be done in 20 minutes (approximation).
Due to php time limitation, this was done in several times.
Articles are grouped by 100 on a topic, all topics in one father.
Impact on other Midgard applications in the same database.
No impact really found.
Impact on the Midgard Administration application
Article management is impacted, database indexes must be added.
e.g.: on article.up in mgd_list_reply_articles.
Why this test?
We have an application to build, and we have to solve 2 difficulties.
First we have a lot of data, 800000 to 1 million (this test).
Another difficulty to solve
Second I suspect transactions to do in phase 2.
Perhaps we must switch to another database.
Next step
If we must have transactions
1. we can use Midgard with ODBC and a commercial database
2. we rewrite the database part of the Midgard library with the native
driver
3. we don't use Midgard but PHP + Transactional database, but big part
is a wheel reinvented.
Conclusion:
The test was OK.
Side effect:
this month documentation on Midgard is not what it would be.
sorry.
Jean-Pierre Arneodo
--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org
To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]
