Discussion on optimizing-cakes-performance

2008-06-10 Thread SeanW
If users commonly search 'product names' you may want to make that field a FULLTEXT index. This will make searches much faster. Have you verified this? Using a fulltext index requires the MATCHES function in the SQL, it doesn't get used if you do a WHERE foo= type query. I don't see any code

Re: CakePHP with PBX System.. Is it doable?

2008-06-05 Thread SeanW
Hi Reza, Most PBX systems log with a feature called Call Detail Recording (or Records), CDR for short. How to get at them depends on the system, but generally there is a card in the PBX with a serial output that spits out the CDR records. Attached to this is often a buffer box that a PC dials

Re: looking for a hosting company

2008-03-28 Thread SeanW
I once had a Godaddy VPS, it started off pretty well but eventually the disk latency became absurd. I presented some tests showing 2 *seconds* for a single disk access in a ticket and was told that's within their tolerances. I canceled the VPS after that. Sean On Mar 28, 6:51 am, phpjoy

Re: looking for a hosting company

2008-03-27 Thread SeanW
On Mar 26, 12:59 pm, Rob Russell [EMAIL PROTECTED] wrote: Anybody hosted Cake on 1and1? I've really liked them so far but I haven't pushed any Cake apps on to that server yet. I had a VPS (somewhere else) and ran in to trouble locking it down so I've been relegated to managed virtual hosting

Re: Logic on Site Index

2008-02-18 Thread SeanW
Look at app/config/routes.php /** * Here, we are connecting '/' (base path) to controller called 'Pages', * its action called 'display', and we pass a param to select the view file * to use (in this case, /app/views/pages/home.thtml)... */ Router::connect('/', array('controller' = 'pages',

Re: Model/controller naming question - object name ends in 's' :

2008-01-13 Thread SeanW
I think you want to look at custom inflection: http://tempdocs.cakephp.org/#TOC41977 And yes, the plural of lens is lenses. Sean On Jan 12, 4:08 pm, Tim [EMAIL PROTECTED] wrote: Hi all, I'm a newbie to CakePHP, and a relative newbie to php. CakePHP looks like just what I was looking for

Re: Accelerating cakePHP

2007-12-16 Thread SeanW
Also look at http://www.ibm.com/developerworks/linux/library/l-tune-lamp-1/ (tuning Linux) http://www.ibm.com/developerworks/linux/library/l-tune-lamp-2.html (tuning Apache and PHP) http://www.ibm.com/developerworks/linux/library/l-tune-lamp-3.html (tuning MySQL) Sean On Dec 16, 3:29 am, majna

Re: Is cake generating inefficient SQL? (uses IN clause)

2007-12-14 Thread SeanW
A covering index might also help, depending on what type of field b.field_2 is. CREATE INDEX cover_field2 ON b (id,field_2); If field_2 is a short varchar then there is a greater chance that mysql will just read the index and grab the data from there, and never touch the table. If you need a

Re: newbie question - multiple functions in a page

2007-12-03 Thread SeanW
On Dec 2, 7:56 pm, Adam Royle [EMAIL PROTECTED] wrote: Using elements is what you want. Inside the elements you can use requestAction to get at any data you wish to use. You can return an array of data directly, or render a view. See tutorial here for an example (and also how to cache the

Re: Load balanced web servers with CakePHP

2007-11-27 Thread SeanW
Cake seems to use the PECL memcache extensions, which I've used elsewhere, and they're solid. I'd look at caching in memcache before NFS mounted disk. Sean On Nov 27, 7:19 am, dericknwq [EMAIL PROTECTED] wrote: I have read about it but nope, never consider it yet. Seems like a pretty good

Re: Multiple Slave Servers?

2007-11-22 Thread SeanW
' = 'my_db' ); - Mike On Nov 21, 3:39 pm, SeanW [EMAIL PROTECTED] wrote: Most of those protocols are balanced at layer 4 (IP and port), the load balancer has no knowledge of the underlying protocol. Just balance port 3306 across your slaves, it'll

Re: Multiple Slave Servers?

2007-11-21 Thread SeanW
For multiple slave servers I'd look at a load balancer, either hardware or ipvs + heartbeat. There's more than just which server do I send it to?, there's also making sure the server is alive and not too lagged. Sean On Nov 20, 8:24 pm, Mike Lewis [EMAIL PROTECTED] wrote: I saw a post about

Re: Multiple Slave Servers?

2007-11-21 Thread SeanW
, 9:08 am, SeanW [EMAIL PROTECTED] wrote: For multiple slave servers I'd look at a load balancer, either hardware or ipvs + heartbeat. There's more than just which server do I send it to?, there's also making sure the server is alive and not too lagged. Sean On Nov 20, 8:24 pm, Mike

Re: Multiple Slave Servers?

2007-11-21 Thread SeanW
', 'login' = '', 'password' = '.', 'database' = 'my_db' ); - Mike On Nov 21, 3:39 pm, SeanW [EMAIL PROTECTED] wrote: Most of those protocols are balanced at layer 4 (IP and port

Re: Simplest usage of the new Auth component?

2007-11-10 Thread SeanW
. Did I forget something? Best regards Arne On Nov 9, 4:25 pm, SeanW [EMAIL PROTECTED] wrote: On Nov 8, 6:33 pm, Arne-Kolja Bachstein [EMAIL PROTECTED] wrote: But when submitting the form, it redirects me back to the login, pre- filling the password field with 32 chars (assume it's

Re: Auth-allow not working at all?

2007-11-10 Thread SeanW
Arne, Good to see you got the other stuff going, I just replied so I guess you can ignore that :) Use $this-Auth-allow(*) to allow access to all actions, or $this- Auth-allow(foo, bar) to allow access to the foo and bar actions of the current controller. Your login handler is allowed access no

Re: Simplest usage of the new Auth component?

2007-11-09 Thread SeanW
On Nov 8, 6:33 pm, Arne-Kolja Bachstein [EMAIL PROTECTED] wrote: But when submitting the form, it redirects me back to the login, pre- filling the password field with 32 chars (assume it's the md5 hash, but why?). That's probably because the authentication is failing, or not being checked.

Re: Simplest usage of the new Auth component?

2007-11-08 Thread SeanW
On Nov 7, 9:07 pm, Arne-Kolja Bachstein [EMAIL PROTECTED] wrote: My goal is to implement the authentication basics directly into /app/ app_controller.php rather than the users controller, as I think it I posted something about this recently, where authentication is done in the main