Hi Phil, The problem isn't the amount of records, it's that you're trying to display too many results on a single page at the same time. For this, there is pagination.
Read this on how to integrate pagination into your app: http://bakery.cakephp.org/articles/view/advanced-pagination-1-2 Kevin, On Sep 28, 4:09 pm, Phil <[EMAIL PROTECTED]> wrote: > Newbie, slow response, wrong tools ? > > I use ms access to 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.php in models > <?php > class Tyre extends AppModel > { > var $name = 'Tyre';} > > ?> > > tyres_controller.php in 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 -~----------~----~----~----~------~----~------~--~---
