+ lots to AD7six's suggestion to look at your asociations between
models. You can find that Cake will pull huge amounts of data out at a
time. For example, if you have something like User hasMany Task and
Task belongsTo User and you set recursive to 2 or 3, you can get a
data structure like:
User
id
name
Task
[0] id
duedate
User
id
name
[1] id
duedate
User
id
name
One thing to do to check is to do pr($this->modelname->findAll());
die(); with debug on 1 or 2 in config/core.php and see what gets
returned.
When you have lots of records, this will definately lead to large
response times (or no response even!). Possible solutions are to set
recursive to -1 or 1 or use the containable behavior.
Ian
On Oct 5, 9:44 am, kaki <[EMAIL PROTECTED]> wrote:
> hi, I can't connect to a MS ACCESS database with cake php .
> could you write your database.php ?
> thanks
>
> [EMAIL PROTECTED]
>
> On 28 sep, 22:09, Phil <[EMAIL PROTECTED]> wrote:
>
> > Newbie, slow response, wrong tools ?
>
> > I use msaccessto run a small business and have decided to replace my
> > app with
> > linux, apache2, postgres 8., cakephp 1.2
>
> > so far i have got as far as adapting the bookmarks tutorial by graham
> > birdhttp://grahambird.co.uk/cake/tutorials/scaffolding.php
>
> > The problem is when I use it with 2500 records the response time is
> > circa 100 secs
>
> > am I ?
> > 1. displaying too big a data set
> > 2. entirely in the wrong software with cakephp
> > 3. should not be using scaffolding
> > 4. made some error with the table or coding
>
> > the only odd thing I have done was to load the table without a
> > primary key
> > change ty_id to id and add created and modified
>
> > code and table below
>
> > tyre.phpin models
> > <?php
> > class Tyre extends AppModel
> > {
> > var $name = 'Tyre';}
>
> > ?>
>
> > tyres_controller.phpin controllers
> > <?php
> > class TyresController extends AppController
> > {
> > var $name = 'Tyres';
> > var $scaffold;}
>
> > ?>
>
> > -- add indexes later
> > DROP TABLE tyres ;
> > CREATE TABLE tyres (
> > --ty_ID SERIAL primary key, -- auto number field
> > ty_product_code varchar(30), -- UNIQUE NOT NULL,
> > ty_short_size integer DEFAULT 1111111 NOT NULL,
> > ty_load integer NOT NULL, -- usually 2 digits
> > ty_speed varchar(2) NOT NULL ,
> > ty_desc varchar(35) NOT NULL
> > );
> > Bulk load data
>
> > -- alter table
> > ALTER TABLE tyres ADD column ty_ID SERIAL;
> > -- add primary key
> > ALTER TABLE tyres ADD PRIMARY KEY (ty_ID);
>
> > ALTER TABLE tyres RENAME COLUMN ty_ID to id;
> > ALTER TABLE ADD COLUMN created TIMESTAMP;
> > ALTER TABLE ADD COLUMN modified TIMESTAMP;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
