Hello Masters,
I am really confused about the durability of MYSQL Database.
in our site we have got a Tree Structure (Of Multilevel marketing Structure), The bussiness logic is..
1.When a person joins out business he will have to get four members in his downline and this will be applied on these four too.. like this the tree goes on..
2. each member can have only four direct member and if he get his fifth one then the rollover will be placed somewhere under his downline where four member is not completed.
So the problem is..
We have programmed it with PHP3 and mysql. It's working fine but sometimes the rollover member placed at the WRONG Position..
our servlet programmer is saying "this is because of MYSQL, Because four rows are being inserted at one time in four tables.and if somehow one table is not inserted then mysql dosen't have the facility to check wether it is inserted in each and every table, that's why the transection got disturbed..
Is it really the Problem..
Please help me as I am really confused about this..
Thanx
I am really confused about the durability of MYSQL Database.
in our site we have got a Tree Structure (Of Multilevel marketing Structure), The bussiness logic is..
1.When a person joins out business he will have to get four members in his downline and this will be applied on these four too.. like this the tree goes on..
2. each member can have only four direct member and if he get his fifth one then the rollover will be placed somewhere under his downline where four member is not completed.
So the problem is..
We have programmed it with PHP3 and mysql. It's working fine but sometimes the rollover member placed at the WRONG Position..
our servlet programmer is saying "this is because of MYSQL, Because four rows are being inserted at one time in four tables.and if somehow one table is not inserted then mysql dosen't have the facility to check wether it is inserted in each and every table, that's why the transection got disturbed..
Is it really the Problem..
Please help me as I am really confused about this..
Thanx