ofbiz-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Adrian Crum <adrian.c...@sandglass-software.com>
Subject Re: run action in Order Search
Date Thu, 14 Aug 2014 22:31:43 GMT
I have worked with OFBiz systems that had millions of orders, and 
performance was not a problem.

I strongly encourage you to spend more time understanding design 
patterns in OFBiz.

Adrian Crum
Sandglass Software
www.sandglass-software.com

On 8/14/2014 6:36 PM, JFradkin@styleline.com wrote:
> I agree they are different.
> The underlying data set might be the same, but sharing a table and using a
> type is not a good idea for performance. The entity maybe could even stay
> the same, but just from a data storage and speed thought it would be better
> to use two tables and eliminate the need for type to be introduced. Also if
> you ever try and read data, when the table is larger even with proper
> indexes it is slower on larger data sets. At least that is what I found
> testing with Postgres (might be different with the ofbiz engine).
> I had 250 concurrent users on a system I was in charge of and I was always
> trying to figure out how to get the speed up. Many of our smaller companies
> were fine, so indexing does make a difference, but when the tables got more
> then say 500,000 records it would get much slower than when the table was
> small. We had all our clients for the most part on one DB. I found when I
> moved some of the realy big clients off to their own instance making the
> over size of the Postgres DB smaller the speed came up (even though that
> client still had the same number of records). I was surprised as I thought
> with proper indexing the number of records in the table would ot
> significantly impact speed. Maybe there were other issues, but I spent a bit
> of time on it and implemented a few more DB (pain separating out the data).
> Thats why I think it would be better to use two tables, but maybe if both
> tables are in the same DB it doesnt make a difference. We are not going to
> have that kind of stress so no worries here it works ok as is.
>
>
>
> -----
> Joel Fradkin
> --
> View this message in context: http://ofbiz.135035.n4.nabble.com/run-action-in-Order-Search-tp4653403p4653546.html
> Sent from the OFBiz - User mailing list archive at Nabble.com.
>

Mime
View raw message