thanks for your mail.
the table is:
CREATE table accs(
id serial NOT NULL,
controller text,
action text,
param text,
created timestamp without time zone DEFAULT now(),
modified timestamp without time zone DEFAULT now(),
env text
);
the insert took time is
one time is 289ms
one time is 386ms
one time is 228ms
one time is 403ms
one time is 232ms
one time is 221ms
one time is 228ms
compared with other sql,these are too big.
the sql is
INSERT INTO "accs" ("created", "modified", "controller", "action", "eve",
"param") VALUES ('now()', 'now()', 'infos', 'intro', 'ie', '')
database is the same pc with php.
Thanks
rimoe
2009/7/7 Carlos Gonzalez Lavin <[email protected]>
> Perhaps a bit more info? How is your table defined? How much time is "too
> many"? What is the query itself
>
> 2009/7/7 Rimoe <[email protected]>
>
> hi,
>> everyone!
>>
>> in the debug state, page has showed the time that has been executed sql.
>> I found, the insert statement has used too many time always.
>>
>> why is it, what can I do for the huge time waste.
>>
>> by the way, my inserted table is very simple.
>> only five columns, and has no any relationships with other tables.
>>
>> Thanks
>> if you know something about the reason,
>> please tell me.
>> Thank you
>>
>>
>> rimoe
>>
>>
>>
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
