| # |
Aug 9th 2008, 05:31 |
AD7six |
achew22: delete all has 2 modes - tell me what they are |
| # |
Aug 9th 2008, 05:31 |
Howard`` |
yeah, trying to figure that ouw now AD7six |
| # |
Aug 9th 2008, 05:30 |
achew22 |
no, its doing a select instead of a delete |
| # |
Aug 9th 2008, 05:30 |
AD7six |
achew22: if it works yes. if you're getting ambiguous field errors no. |
| # |
Aug 9th 2008, 05:29 |
AD7six |
Howard``: entirely up to you. remember that the more you shard the more cross db joins you risk/need. |
| # |
Aug 9th 2008, 05:29 |
achew22 |
AD7six: is this what your meant? http://bin.cakephp.org/view/543725084 |
| # |
Aug 9th 2008, 05:28 |
Howard`` |
AD7six, curious, would it be disasterous to make a seperate db for each user id? |
| # |
Aug 9th 2008, 05:27 |
kaotisch |
achew did you want me to paste my code to the bin, or did you mean someone else? |
| # |
Aug 9th 2008, 05:26 |
AD7six |
achew22: $condition['Not']['Model.field'] = $arrayOrId |
| # |
Aug 9th 2008, 05:26 |
achew22 |
its not really intuitive I am trying to delete all the things in the DB that aren't in $results |
| # |
Aug 9th 2008, 05:26 |
AD7six |
since when is that intuitive |
| # |
Aug 9th 2008, 05:26 |
AD7six |
achew22: where did you get " '`id` NOT' " from |
| # |
Aug 9th 2008, 05:25 |
Howard`` |
not sure if that's logical |
| # |
Aug 9th 2008, 05:25 |
Howard`` |
What I'm thinking about doing here is allowing like 100 accounts per database |
| # |
Aug 9th 2008, 05:25 |
achew22 |
AD7six: would you be willing to look at this? http://bin.cakephp.org/view/23017039 |
| # |
Aug 9th 2008, 05:25 |
Howard`` |
yeah :) |
| # |
Aug 9th 2008, 05:25 |
AD7six |
Howard``: a base26 sharding system :) |
| # |
Aug 9th 2008, 05:24 |
Howard`` |
something along the lines of 26 databases depending on the first character of the username |
| # |
Aug 9th 2008, 05:24 |
pgcd_away |
ok, i'm having serious trouble getting swfupload 2.1 to work with cake 1.2, and there seem to be no useful tutorial... anybody here has done something with it? |
| # |
Aug 9th 2008, 05:24 |
Howard`` |
I've seen sharding in use actually |
| # |
Aug 9th 2008, 05:24 |
AD7six |
Howard``: well that's effectively dbo layer logic - i.e. doesn't influence any of your app code at all if it's done right. |
| # |
Aug 9th 2008, 05:22 |
AD7six |
Howard``: you'd be better off thinking about sharding etc. if/when you have to of course. |
| # |
Aug 9th 2008, 05:22 |
Howard`` |
thanks AD7six, checking that and sharding out now |
| # |
Aug 9th 2008, 05:21 |
achew22 |
hrm... |
| # |
Aug 9th 2008, 05:21 |
AD7six |
achew22: yes |
| # |
Aug 9th 2008, 05:21 |
achew22 |
AD7six: does deleteAll work? |
| # |
Aug 9th 2008, 05:21 |
kaotisch |
Hey all, I have an issue with the Auth comp. When I add it as component in app_controller, and call any action (for example sadf.com/notes/view/ ), i should get redirected to sadf.com/users/login/ but instead i get redirected to sadf.com/notes/view/users/login and it ends up in an infinite redirect like sadf.com/notes/view/users/login/users/login/users/login. Anyone has an idea why this could happen? |
| # |
Aug 9th 2008, 05:20 |
AD7six |
have a look at that as a starting point: http://trac.assembla.com/cake-base/browser/branches/sample_app/app/models/mi_email.php |
| # |
Aug 9th 2008, 05:20 |
Howard`` |
I need to be able to reference this for the system |
| # |
Aug 9th 2008, 05:20 |
Howard`` |
Basically quick references like who the e-mail belongs to, subject header, the to and from fields |
| # |
Aug 9th 2008, 05:20 |
AD7six |
what associative records |
| # |
Aug 9th 2008, 05:19 |
Howard`` |
well I want to be able to hold the associative records for users |
| # |
Aug 9th 2008, 05:19 |
AD7six |
for emails - what benefit do you expect putting them in athe db. |
| # |
Aug 9th 2008, 05:19 |
Howard`` |
is MySQL a good system to shard with or would you reccomend a different database? |
| # |
Aug 9th 2008, 05:18 |
Howard`` |
I'm sort of wondering whether I should store the contents etc in the database or on the filesystem |
| # |
Aug 9th 2008, 05:18 |
Howard`` |
Thanks AD7six, I'm building up the idea with cakephp .. it's going to be a heavy e-mail system |
| # |
Aug 9th 2008, 05:17 |
AD7six |
Howard``: look up sharding |
| # |
Aug 9th 2008, 05:17 |
Howard`` |
say I wanted to store millions of rows, how could I do that efficiently |
| # |
Aug 9th 2008, 05:16 |
Howard`` |
I'm not sure how the whole load balancing thing works out |
| # |
Aug 9th 2008, 05:16 |
Howard`` |
Does anyone know anything about spanning one database table across several servers? |
| # |
Aug 9th 2008, 05:01 |
pgcd_away |
(cake1.2 and SWFU 2.1) |