Zotonic
Zotonic
zotonic@conference.zotonic.com
Wednesday, 29 August 2012< ^ >
arjan has set the subject to: Zotonic - the Erlang CMS
Room Configuration

GMT+2
[07:24:15] Ilya Rezvov leaves the room
[07:29:55] Ilya Rezvov joins the room
[07:42:22] Ilya Rezvov leaves the room
[09:11:22] Ilya Rezvov joins the room
[09:11:43] Ilya Rezvov leaves the room: Replaced by new connection
[09:11:44] Ilya Rezvov joins the room
[14:48:39] <Ilya Rezvov> i have 1 million rsc
[14:49:25] <Ilya Rezvov> zotonic slowed markedly
[14:49:37] <Ilya Rezvov> i think replace products in own table
[14:51:08] <Marc Worrell> check the queries, to see which queries slow down.
[14:51:16] <Marc Worrell> might be some index that is not good
[14:51:24] <Marc Worrell> then we can change it
[14:51:27] <Ilya Rezvov> i search by pivot field
[14:51:45] <Ilya Rezvov> and have join
[14:51:46] <Marc Worrell> (we are running with several 100K and not seeing an impact yet)
[14:51:56] <Marc Worrell> maybe try an explain of that query?
[14:52:06] <Ilya Rezvov> yes
[14:52:11] <Ilya Rezvov> i try it evening
[14:52:16] <Marc Worrell> ok, thanks
[14:52:17] <Ilya Rezvov> i will try :)
[15:04:00] <Ilya Rezvov> hm, i just rebuild search indexes
[15:04:21] <Ilya Rezvov> and it works normal
[15:05:25] <Marc Worrell> oh, maybe a full text index that was inbalanced?
[15:05:48] <Marc Worrell> Time to get a real full text indexer integrated
[15:06:31] <Marc Worrell> MySQL has a max of around 1 million items in its FT index, I guess PostgreSQL maxes out between 1 and 10M
[15:07:18] <Ilya Rezvov> i think i replace products in own table yet
[15:07:54] <Ilya Rezvov> i dont have tools for explore props in sql query now
[15:08:37] <Ilya Rezvov> i think own table and model be better
[15:15:19] <Ilya Rezvov> how i can add phone property in signup form?
[15:15:50] <Ilya Rezvov> i look at code, but i don't see approach for it
[15:19:32] <Marc Worrell> there is a {% all include "_signup_extra.tpl" %}
[15:19:50] <Marc Worrell> and then in the code:
[15:19:51] <Marc Worrell> case z_notifier:foldl(signup_check, {ok, Props, SignupProps}, Context) of
{ok, Props1, SignupProps1} ->
[15:20:22] <Marc Worrell> where you can add your own properties
[15:20:34] <Marc Worrell> those props will be added to the page (rsc)
[15:26:10] <Ilya Rezvov> thx
[15:26:33] <Ilya Rezvov> i need write observe_signup_check?
[15:29:48] <Ilya Rezvov> observe_signup_check({signup_check, Args}, Context) ?
[16:27:21] <Marc Worrell> observe_signup_check(signup_check, {ok, Props, SignupProps}, Context)
[16:27:35] <Marc Worrell> it is a /3 -> used in a fold
[16:37:54] <Ilya Rezvov> ok
[16:38:02] <Ilya Rezvov> what i need return?
[17:44:21] Ilya Rezvov leaves the room
[17:44:22] Ilya Rezvov joins the room
[17:44:25] Ilya Rezvov leaves the room
[19:13:30] Ilya Rezvov joins the room
[19:16:37] Ilya Rezvov leaves the room
[20:01:49] <Marc Worrell> {ok, Props, SignupProps}
[20:17:16] Ilya Rezvov joins the room
[23:20:09] Ilya Rezvov leaves the room: Replaced by new connection
[23:20:10] Ilya Rezvov joins the room
Powered by ejabberd Powered by Erlang Valid XHTML 1.0 Transitional Valid CSS!