Is there any reason you are not paging it and fetching only 20, or 50 or
100 records at a time? That would significantly speed things up for you...
Regards,
--Kevin
--
Sign up for our Newsletter for updates.
http://cakephp.org/newsletter/signup
We will soon be closing this Google Group. But do
hello everyone, this is my situation.
MSSQL server with query on a single table; timer says 4.47s, SQL Log says
1375 rows in 110ms.
Time spent in "controller action" is 3600ms and I further tried to inspect
the controller code, printing elapsed microseconds: it seems like the
assignment of the
what MySQL (I think) will never be able to and takes
>> so many steps forward. Even from MSSQL.
>>
>> A lot of people take the decision to use MSSQL because "that's what
>> they've used previously" but this does not make it the right choice.
>> Sure, y
s does not make it the right choice.
> Sure, you may not have a choice now but what about in the future?
> So please, think about it and don't get evangelist on me. :)
>
> Best Regards,
> Borislav Sabev.
>
>
>
> On Thursday, 29 May 2014 00:19:09 UTC+3, Jordan Hopfner wro
ry this change when I go to use SQL Server again.
>>>>> It would be great if the core team would make these changes to Cake :)
>>>>>
>>>>> On Friday, August 8, 2014 10:30:20 PM UTC-6, Alan Read wrote:
>>>>>>
>>>>>> Changing the lin
gt; Sure, you may not have a choice now but what about in the future?
> So please, think about it and don't get evangelist on me. :)
>
> Best Regards,
> Borislav Sabev.
>
>
> On Thursday, 29 May 2014 00:19:09 UTC+3, Jordan Hopfner wrote:
>>
>> Hey guys,
&
evangelist on me. :)
Best Regards,
Borislav Sabev.
On Thursday, 29 May 2014 00:19:09 UTC+3, Jordan Hopfner wrote:
>
> Hey guys,
>
> I'm using the latest version of Cake (2.5.1) and am having a problem with
> extremely slow connections to a MSSQL server. A controller action
anging the line:
>>>>>
>>>>> 772) $prepareOptions += array(PDO::ATTR_CURSOR => PDO::CURSOR_SCROLL);
>>>>>
>>>>> to
>>>>>
>>>>> 772) $prepareOptions += array(PDO::ATTR_CURSOR => PDO::
>>>>
LL);
>>>>
>>>> to
>>>>
>>>> 772) $prepareOptions += array(PDO::ATTR_CURSOR => PDO::*CURSOR_FWDONLY*
>>>> );
>>>>
>>>> in the _execute function inside of Sqlserver.php solved this issue for
>>>> me
(PDO::ATTR_CURSOR => PDO::*CURSOR_FWDONLY*
>>> );
>>>
>>> in the _execute function inside of Sqlserver.php solved this issue for me
>>>
>>> On Wednesday, May 28, 2014 5:19:09 PM UTC-4, Jordan Hopfner wrote:
>>>>
>>>> Hey guys,
>&
tion inside of Sqlserver.php solved this issue for me
>>
>> On Wednesday, May 28, 2014 5:19:09 PM UTC-4, Jordan Hopfner wrote:
>>>
>>> Hey guys,
>>>
>>> I'm using the latest version of Cake (2.5.1) and am having a problem
>>> with extremel
ednesday, May 28, 2014 5:19:09 PM UTC-4, Jordan Hopfner wrote:
>>
>> Hey guys,
>>
>> I'm using the latest version of Cake (2.5.1) and am having a problem with
>> extremely slow connections to a MSSQL server. A controller action that only
>> has one simple
PDO::ATTR_CURSOR => PDO::*CURSOR_FWDONLY*);
inside of the _execute function
Let me know if this solves your issue.
On Wednesday, May 28, 2014 5:19:09 PM UTC-4, Jordan Hopfner wrote:
>
> Hey guys,
>
> I'm using the latest version of Cake (2.5.1) and am having a problem with
> extre
Jordan Hopfner wrote:
>
> Hey guys,
>
> I'm using the latest version of Cake (2.5.1) and am having a problem with
> extremely slow connections to a MSSQL server. A controller action that only
> has one simple select statement is taking an upwards of 50 seconds to
>
Again, I'm using MSSQL not MySQL. I suppose I could give 2.4 a shot,
wouldn't hurt to try.
On Sunday, June 15, 2014 3:54:54 AM UTC-6, Michael Houghton wrote:
>
> I suspect this is a MYSQL setting. Out if interest, have you tried version
> 2.4 or below?
--
Like Us on FaceBook https://www.facebo
Interesting. Can you open a ticket in github with this issue? Meanwhile I
would suggest globally setting that setting in your mysql server, it will
make it run faster with CakePHP. Alternatively I would suggest upgrading to
MySQL 5.6
On Monday, June 16, 2014 2:34:35 PM UTC+2, archana goyal wrot
Hi,
My CakePHP 3 application taking more then 30 sec to load.This is not a big
application I just started work on this application.
When I enable init in Config/app.php got following issue:
SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other
unbuffered queries are activ
I suspect this is a MYSQL setting. Out if interest, have you tried version 2.4
or below?
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsu
I haven't tried 3.0 yet. I've been waiting for at least a beta to come out
before I try it.
On Tuesday, June 10, 2014 11:25:02 PM UTC-6, José Lorenzo wrote:
>
> Have you tried with CakePHP 3.0, just for curiosity?
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http:/
Have you tried with CakePHP 3.0, just for curiosity?
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop rece
Thanks for the help gentlemen, I'm at a loss here. Unfortunately upgrading
PHP to 5.5 isn't in the cards for our production server at the moment. My
only other option is to develop the application in C# and .NET (yuck, lol).
On Wednesday, June 4, 2014 8:38:52 AM UTC-6, Dakota wrote:
>
> We've go
We've got a full application, doing joins, inserts, etc. Also uses
FileStream. No issues, runs just as fast as MySQL
On Wednesday, 4 June 2014 15:58:20 UTC+2, Jordan Hopfner wrote:
>
> What kind of tests/queries are you guys doing? Just verifying that you can
> connect or pulling back a bunch of
What kind of tests/queries are you guys doing? Just verifying that you can
connect or pulling back a bunch of rows?
On Tuesday, June 3, 2014 9:57:43 PM UTC-6, Dakota wrote:
>
> I have no issues with MsSQL and Cakephp 2.5 (migrated to 3.0 dev though
> now). Running sql 2012 and php 5.5.
>
> You c
I have no issues with MsSQL and Cakephp 2.5 (migrated to 3.0 dev though now).
Running sql 2012 and php 5.5.
You can get the php 5.5 sqlserver driver from
http://www.apachelounge.com/viewtopic.php?t=5985
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.c
ake on this project unfortunately.
>>>>
>>>> On Sunday, June 1, 2014 4:50:07 PM UTC-6, Charlie Topjian wrote:
>>>>>
>>>>> I experienced similar problems with my stack. What version of MYSQL
>>>>> are you using?
>>>>>
>&
t;>
>>>> On Wednesday, May 28, 2014 4:19:09 PM UTC-5, Jordan Hopfner wrote:
>>>>>
>>>>> Hey guys,
>>>>>
>>>>> I'm using the latest version of Cake (2.5.1) and am having a problem
>>>>> with extremel
t;>
>> On Sunday, June 1, 2014 4:50:07 PM UTC-6, Charlie Topjian wrote:
>>>
>>> I experienced similar problems with my stack. What version of MYSQL are
>>> you using?
>>>
>>> On Wednesday, May 28, 2014 4:19:09 PM UTC-5, Jordan Hopfner wrote:
>&g
On Wednesday, May 28, 2014 4:19:09 PM UTC-5, Jordan Hopfner wrote:
>>>
>>> Hey guys,
>>>
>>> I'm using the latest version of Cake (2.5.1) and am having a problem
>>> with extremely slow connections to a MSSQL server. A controller action that
>>
n Wednesday, May 28, 2014 4:19:09 PM UTC-5, Jordan Hopfner wrote:
>>
>> Hey guys,
>>
>> I'm using the latest version of Cake (2.5.1) and am having a problem with
>> extremely slow connections to a MSSQL server. A controller action that only
>> has one simple
I experienced similar problems with my stack. What version of MYSQL are you
using?
On Wednesday, May 28, 2014 4:19:09 PM UTC-5, Jordan Hopfner wrote:
>
> Hey guys,
>
> I'm using the latest version of Cake (2.5.1) and am having a problem with
> extremely slow connections
Hey guys,
I'm using the latest version of Cake (2.5.1) and am having a problem with
extremely slow connections to a MSSQL server. A controller action that only
has one simple select statement is taking an upwards of 50 seconds to
complete. I don't think it's the select statement
15, 2013 at 2:23 PM, Quoc Lam wrote:
> Hi there,
>
> I am new to CakePHP and is trying to setup my first "Hello World" project.
> When working on that, I experienced a very slow response from CakePHP when
> performing a simple query to the DB.
>
> Here are t
Hi there,
I am new to CakePHP and is trying to setup my first "Hello World" project.
When working on that, I experienced a very slow response from CakePHP when
performing a simple query to the DB.
Here are the steps that I have done:
1. Download the CakePHP framework (2.3.0
Tried ClassRegistry::init() as well, no help...
Upon further looking, it seems that although having so many models is
bogging things down, it is really the calling up those model across multiple
databases that may be the real culprit.
When I incrementally introduce each method call in the Contro
Upon further looking, it seems that although having so many models is
bogging things down, it is really the calling up those model across multiple
databases that may be the real culprit.
When I incrementally introduce each method call in the Controller’s
function,
the time it takes to load the
Hello,
I'm wondering about the best way to speed up my page load.
I have a View that displays a table with data from around 15 different
Models.
Many of them are unrelated. A few are in different databases.
The MySQL query is around 2 seconds (I can see from an sql_dump),
but the page can take
escribed with cakephp.
> mostly they are connected with previous versions of cakephp.
> but some of them are about new version like for example:
> http://blog.kamisama.me/2012/02/17/cakephp-reverse-routing-is-slow-and-what-you-can-do/
> I started to work with cakephp last 2 days
hp.
but some of them are about new version like for example:
http://blog.kamisama.me/2012/02/17/cakephp-reverse-routing-is-slow-and-what-you-can-do/
I started to work with cakephp last 2 days and i realy like this framework
but i'm a bit concerned about these speed issues.
i don't want
>
> Sometimes looking at other code can be helpful, i spent a lot of time
> reading the code in the bakery and came up with this for a quick start -
> this.is-slick.com
>
--
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send
t could not be budgeted with a major version
> change...
>
> But, hey!, the development still feels slow! All framework classes are
> full of magic variables sparsely documented (API? blog tutorial?
> Cookbook?). Still I can't get the Cake way of doing things. Still I feel
>
ention). Then I found that helpers
>> must be accessed in a different way, so my layouts were to be rewritten. All
>> the way here, nothing that could not be budgeted with a major version
>> change...
>>
>> But, hey!, the development still feels slow! All framework
the PSR0 thing, just can't imagine why they only in the
> world chose this ugly and cumbersome convention). Then I found that helpers
> must be accessed in a different way, so my layouts were to be rewritten. All
> the way here, nothing that could not be budgeted with a major version
&g
rewritten.
All the way here, nothing that could not be budgeted with a major version
change...
But, hey!, the development still feels slow! All framework classes are full
of magic variables sparsely documented (API? blog tutorial? Cookbook?).
Still I can't get the Cake way of doing thing
Are assets being loaded correctly?
On Tuesday, May 29, 2012 3:28:25 AM UTC-4:30, Ernesto wrote:
>
> i forgot to say i'm usign Cake 2.2.0-RC1 on a Win7 server
>
> Il giorno martedì 29 maggio 2012 09:51:28 UTC+2, Ernesto ha scritto:
>>
>> Hi all!
>>
>>
;> Hi all!
>>
>> i noticed that Cake gets very, very slow (about 50x times slower) if i
>> load assets from Plugins.
>>
>> Here's my layout code
>>
>> http://www.w3.org/1999/xhtml";>
>>
>> > echo $this->Html->charset(
i forgot to say i'm usign Cake 2.2.0-RC1 on a Win7 server
Il giorno martedì 29 maggio 2012 09:51:28 UTC+2, Ernesto ha scritto:
>
> Hi all!
>
> i noticed that Cake gets very, very slow (about 50x times slower) if i
> load assets from Plugins.
>
> Here's my layout
Hi all!
i noticed that Cake gets very, very slow (about 50x times slower) if i load
assets from Plugins.
Here's my layout code
http://www.w3.org/1999/xhtml";>
Html->charset();
echo "". $title ."";
echo $this->Html->meta("icon");
echo $thi
hi,
what is your speed expectation ? do you have any minimum and maximum time
limit ?
why not try to do the save only once...like firing all the insert in 1 shot
to the db.
or just create raw insert command and run the execute..
On Tue, May 8, 2012 at 12:27 AM, John Hardy wrote:
> While cod
While code optimization should be done, i would be more interested in your
network, database setup/tuning and your hardware specs.
Test your algorithm outside of the cake framework to compare speeds
On May 7, 2012 7:48 AM, "supp...@deep-coding.net"
wrote:
> Hey,
>
> I have a problem, I have to
Hey,
I have a problem, I have to handle many database requests, but it
tooks to much time.
The user can upload a xml file, then I am running a foreach, to create
an array from the data of the xml file.
Then I am saving this data with the save() method, but it tooks to
much time.
For testing I have
On Tuesday, April 17, 2012 6:00:05 AM UTC-7, Farah wrote:
>>>
>>> I'm not expert in CakePHP, but its very clear that the ACL is slow if my
>>> tables database acos, aros and aros_acos over thousand rows.
>>>
>>> Just a simple $this->Acl->check()
Thanks for the reply!
On Tuesday, April 17, 2012 11:16:49 AM UTC-3, stork wrote:
>
> Also, check out these projects
> http://plugins.cakephp.org/packages?query=acl
> if you do not need wheel with some special shape.
>
On Tuesday, April 17, 2012 11:16:49 AM UTC-3, stork wrote:
>
> Also, check out
problem. Also, make sure the engine is innodb.
>
> 1:
> http://blog.loadsys.com/2008/03/19/cakephp-12-tuning-the-acl-via-mysql/
>
> On Tuesday, April 17, 2012 6:00:05 AM UTC-7, Farah wrote:
>>
>> I'm not expert in CakePHP, but its very clear that the ACL is slow if m
'm not expert in CakePHP, but its very clear that the ACL is slow if my
> tables database acos, aros and aros_acos over thousand rows.
>
> Just a simple $this->Acl->check() runs over 500 queries and its clear that
> its not the acl generate that, it uses the Tree behavior to find
Also, check out these projects
http://plugins.cakephp.org/packages?query=acl
if you do not need wheel with some special shape.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
wit
> 1. http://www.visuallizard.com/blog/2009/10/19/241
> 2.
> http://www.mainelydesign.com/blog/view/speeding-up-cakephp-acl-component
> 3.
> http://phpknight.com/cakephp-acl-controlled-application-slow-performance-problem/
>
1. 2009/10
2. 2010/05
3. 2010/06
Better use curr
I'm not expert in CakePHP, but its very clear that the ACL is slow if my
tables database acos, aros and aros_acos over thousand rows.
Just a simple $this->Acl->check() runs over 500 queries and its clear that
its not the acl generate that, it uses the Tree behavior to find th
1. Do you store sessions in database? If yes, is it the same database as
the one with application data? If yes, why? And why not use other
(memcache) storage for sessions?
2. Stop blaming core code for slowness, until you'll be able to write short
example NOT using your own classes like Session
$this->Auth->user('id')), $controller . "/" .
$acao["Acao"]["alias"])) {
$this->Session->write("Auth.Permissions." .
$controller . "." . $acao["Acao"]["alias"], true);
> Any one can help me with this ?
Not me, sorry. This is example, how should NOT look code of CakePHP
application, controller should be as slim as possible.
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://as
Hi AD7six, I'm not sure that I understand what you mean.
Do you mean to say that concurrent requests are not possible for a given
user?
On Monday, April 9, 2012 4:24:32 AM UTC-4, AD7six wrote:
>
>
>
> On Thursday, 5 April 2012 17:00:49 UTC+2, Dan Moseley wrote:
>>
>> Hi,
>> I have been experienci
On Thursday, 5 April 2012 17:00:49 UTC+2, Dan Moseley wrote:
>
> Hi,
> I have been experiencing extremely long run times for some calls to $this->
> Auth->user('id').
>
> Most requests spend 0 time in this method, but seemingly random requests
> are taking upwards of 60 seconds..
>
Probably bec
Hi, how can you see the speed this request needs?
Am Donnerstag, 5. April 2012 17:00:49 UTC+2 schrieb Dan Moseley:
>
> Hi,
> I have been experiencing extremely long run times for some calls to $this->
> Auth->user('id').
>
> Most requests spend 0 time in this method, but seemingly random requests
As far as I know this is obtained from the user session, how are you
handling sessions?
El jueves, 5 de abril de 2012 17:00:49 UTC+2, Dan Moseley escribió:
>
> Hi,
> I have been experiencing extremely long run times for some calls to $this->
> Auth->user('id').
>
> Most requests spend 0 time in
Hi,
I have been experiencing extremely long run times for some calls to $this->
Auth->user('id').
Most requests spend 0 time in this method, but seemingly random requests
are taking upwards of 60 seconds..
Does anyone have any ideas or recommendations on this problem?
Thanks in advance,
Dan
--
Thanks for the time and ideas. I continue working on both methods.
On Fri, Oct 28, 2011 at 1:47 PM, AD7six wrote:
>
>
> On Oct 28, 12:37 pm, "Constantin.FF" wrote:
> > Probably this could work but will be almost impossible to calculate
> > the step for moveDown
>
> _WHY_ would you need to calcu
On Oct 28, 12:37 pm, "Constantin.FF" wrote:
> Probably this could work but will be almost impossible to calculate
> the step for moveDown
_WHY_ would you need to calculate that? The suspicion arises that you
aren't reading much of what I write.
> of each post also in this action are involved
Probably this could work but will be almost impossible to calculate
the step for moveDown of each post also in this action are involved
parents and children so in the $newSort each post is as post_id =>
order number. So if I do it like you suggested, first I will have to
separate posts with same pa
On Oct 28, 11:16 am, Constantin FF wrote:
> Is there a better way for doing that? There is something similar in other
I haven't written anything that implied/suggested/required changing
your existing interface, only your php code.
function _sortPosts($newSort){
Is there a better way for doing that? There is something similar in other
CSM like joomla
On Fri, Oct 28, 2011 at 12:11 PM, AD7six wrote:
>
>
> On Oct 28, 10:58 am, Constantin FF wrote:
> > Not a deja vu, just decided that will be much more comfortable to use a
> > field with an order number an
On Oct 28, 10:58 am, Constantin FF wrote:
> Not a deja vu, just decided that will be much more comfortable to use a
> field with an order number and just once to click "Save order" than
> continuously clicking the moveDown or moveUp links until the desired
> position.
Who suggested doing that?
six wrote:
>
>
> On Oct 28, 10:09 am, "Constantin.FF" wrote:
> > I need my tree sorted by each post sort value. Here is the function
> > dealing with this. But it is executed extremely slow if some of the
> > parents has more than 20-30 childr
On Oct 28, 10:09 am, "Constantin.FF" wrote:
> I need my tree sorted by each post sort value. Here is the function
> dealing with this. But it is executed extremely slow if some of the
> parents has more than 20-30 children
>
> fun
I need my tree sorted by each post sort value. Here is the function
dealing with this. But it is executed extremely slow if some of the
parents has more than 20-30 children
function _sortPosts($newSort){
foreach ($newSort AS $id => $va
I usually use firebug/webinspector to make sure its not a static asset
blocking the page loading. If it isn't I profile the page with xdebug
and find out where/why its slow.
-Mark
On Jul 27, 8:51 pm, leafchild wrote:
> I notice loading page is extremely slow.
>
> Those pages are
actually, I installed 2 cakephp at same server.
One I installed to sub-domain side is ok but
the other installed to webroot dir is slow.
On Thu, Jul 28, 2011 at 4:44 AM, AD7six wrote:
>
>
> On Jul 28, 7:26 am, euromark wrote:
> > yeah, probably a cheap webhosting pack
worth the time to find out why a simple static page is
> > extremely slow rather then just wack the html_cache plugin in the
> > mix ;). A slow static page probably means the entire cake app is slow.
>
> > On Jul 28, 3:25 am, Eugenio wrote:
>
> > > Try with the ht
yeah, probably a cheap webhosting package on a shared environment
sounds like it, anyway.
correct me if i'm wrong
mark
On 28 Jul., 08:45, WyriHaximus wrote:
> Tbh it's worth the time to find out why a simple static page is
> extremely slow rather then just wack the html_cac
Tbh it's worth the time to find out why a simple static page is
extremely slow rather then just wack the html_cache plugin in the
mix ;). A slow static page probably means the entire cake app is slow.
On Jul 28, 3:25 am, Eugenio wrote:
> Try with the html cache
>
Try with the html cache plugin;
http://bakery.cakephp.org/articles/mattc/2009/03/20/html-cache-helper
It will really speed it up, just be careful and remember to clean cache
after updates.
2011/7/27 leafchild
> I notice loading page is extremely slow.
>
> Those pages are not connec
I notice loading page is extremely slow.
Those pages are not connected to DB. Just simple static page.
How can I make it faster to load these pages?
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http
hp
On Jul 2, 2011, at 9:03 AM, me...@yahoo.com wrote:
> custom routes slow down my application
>
> I have loop in the routes in which I'm connecting and processing more
> than 100 custom routes but now my app is experiencing hard time when
> is loading
> Render Controller
custom routes slow down my application
I have loop in the routes in which I'm connecting and processing more
than 100 custom routes but now my app is experiencing hard time when
is loading
Render Controller Action 6600 ms
Any suggestion how to resolve this
--
Our newest site for the comm
On Tue, May 31, 2011 at 5:58 PM, thom wrote:
> On Tue, May 31, 2011 at 5:53 PM, Jens Dittrich wrote:
>> eventually adding some indexes might also help, see:
>> http://www.mainelydesign.com/blog/view/speeding-up-cakephp-acl-component
>>
>
> OK. I'll try it. Thank you everyone.. :)
>
Done! It real
On Tue, May 31, 2011 at 5:53 PM, Jens Dittrich wrote:
> eventually adding some indexes might also help, see:
> http://www.mainelydesign.com/blog/view/speeding-up-cakephp-acl-component
>
OK. I'll try it. Thank you everyone.. :)
--
Regards,,,
mastanto (thom_)
http://mynameisthom.tumblr.com
http:
eventually adding some indexes might also help, see:
http://www.mainelydesign.com/blog/view/speeding-up-cakephp-acl-component
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with
I assume you have used the build_acl function from the tutorial in the book.
I had the same experience in an application with 50 controllers and about 5
functions average per controller. I think the main problem is, that the ACL
behaviour is building a tree and this tree has to be sortet after e
Hello,, I am facing a problem in building acl (build_acl). In the
beginning, it was no problem. Everything is OK. But, when my
controllers are increasing, building acl is getting slower and
'heavey'. I got maximum exceed. I've increased the time to 240
seconds. But still, appears. Some times, I hav
Hi :)
Thank you so much for the answers.
After a long time serching the internet I found this '--skip-name-
resolve' thing and put it on my my.ini file.
The most funny was that only the Ubuntu Server was taking all this
time to connect the database everytime.
I tried installing WAMP on my PC an
http://dev.mysql.com/doc/refman/5.1/en/server-options.html#option_mysqld_skip-name-resolve
On Apr 26, 8:12 pm, Hartmann wrote:
> Hello everybody!
>
> I've installed and configured cake 1.3.8 on an Ubunutu Server 10.10
> all right.
>
> Before configuring the database, the cake home page was taking
Well of course a DB on the same server should connect much faster than
a DB on an external server. Yet in your case it's on the same LAN so
there shouldn't be huge delays with it!
The best thing to do is as "circket" suggested. Create a simple PHP-
Script page that uses normal DB connection functi
On Tue, Apr 26, 2011 at 9:29 AM, Diogo Hartmann wrote:
> Something interesting to add:
> When I use a localhost database the page are dispalyed very fast.
> Is anything wrong with usign an external database?
Ask yourself if there may be something wrong with accessing YOUR
external database. The n
Something interesting to add:
When I use a localhost database the page are dispalyed very fast.
Is anything wrong with usign an external database?
Atenciosamente,
Diogo Hartmann
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Que
Hello everybody!
I've installed and configured cake 1.3.8 on an Ubunutu Server 10.10
all right.
Before configuring the database, the cake home page was taking 0.15 s
to load and was alerting that it wasn't able to connect to the
database (of course)...
So, I configured my database.php (in my cas
#1 See how many SQL queries your page runs and if any of them are long
runing
#2 Use Xdebug and profile your code
HTH
Tarique
On Tue, Mar 22, 2011 at 5:16 AM, cake-learner wrote:
> Is there anything I need to do before putting my app on live.
>
> Now i set false to Cache.disable and 0 to debu
Is there anything I need to do before putting my app on live.
Now i set false to Cache.disable and 0 to debug, but looks like
it takes quite some time to load the page. If there is any way to find
a bottle neck I would appreciate, too.
--
Our newest site for the community: CakePHP Video Tutorial
TimG:
Verify that you have an index on parent_id column in categories table
(as well as a separate index on the id column). ContainableBehavior
usually tries to generate a LEFT JOIN with the belongsTo and the
hasOne related tables, so without the proper indexes, the database may
be resorting to a
It looks like it's just the way it is. Because of the way the
associations are it has to query each variation. I just removed the
variations from the containable and queried them separately and then
combined the arrays in PHP. Much quicker now.
Thanks for everybody's help!
--
Our newest site for
Paste the query(s) that is being generated
Cheers
Tarique
On Mon, Jan 31, 2011 at 11:47 PM, TimG wrote:
> Here is the model for Category:
> var $hasAndBelongsToMany = array(
>'Product' => array(
>'className' => 'Product',
>'joinTable' => 'categories_produ
Here is the model for Category:
var $hasAndBelongsToMany = array(
'Product' => array(
'className' => 'Product',
'joinTable' => 'categories_products',
'foreignKey' => 'category_id',
'associationForeignKey' => 'product_id'
1 - 100 of 341 matches
Mail list logo
