Will do, thanks for the suggestion On 29 Sep, 04:37, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
