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 bird http://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 -~----------~----~----~----~------~----~------~--~---
