*** bonro011 has joined #ingres | 02:54 | |
*** bonro01 has quit IRC | 02:57 | |
*** Deyan has joined #ingres | 04:12 | |
Deyan | hello | 04:13 |
---|---|---|
pboro | hi Deyan | 04:19 |
*** thiagomz has joined #ingres | 04:24 | |
*** Deyan has quit IRC | 04:44 | |
thiagomz | guys, when i run optimizedb it invalidate the executions plan at memory ? | 04:58 |
thiagomz | and generate a new on ? | 04:58 |
pboro | execution plan normally only exist during the execution of a query, but cache_dynamic stores them? do you mean whether cache_dynamic invalidates the cached plans? | 05:05 |
thiagomz | pboro: i have been working with oracle and now i am a ingres dba too... so i have someone concepts from oracle that i have to convert to ingres, in oracle when i run a sql it create a plan on memory, if i run it again my plan is on memory and it doesn't need to create it again.... | 05:07 |
thiagomz | is in ingres the same ? | 05:08 |
thiagomz | or ingres create a plan for every sql run... | 05:08 |
pboro | there is a new plan every time if you don't have cache_dynamic enabled in CBF | 05:09 |
thiagomz | tkz ! | 05:09 |
pboro | I tried cache_dynamic a month ago on 9.2 with patch 13322, but it was buggy :( | 05:10 |
pboro | I hope they get it fixed, it's a pretty new feature | 05:10 |
thiagomz | [ingres@sel-did-01 files]$ grep cache_dynamic config.dat | 05:11 |
thiagomz | :( | 05:11 |
thiagomz | II 2.6/0604 (a64.lnx/00) | 05:11 |
thiagomz | :( | 05:11 |
pboro | oh well that's pretty old :) | 05:11 |
thiagomz | Lol!!! | 05:12 |
thiagomz | i known | 05:12 |
thiagomz | pboro: i am using powerbuilder with odbc .... | 05:12 |
thiagomz | and i am with a screen slow.... | 05:12 |
thiagomz | at my company system... | 05:12 |
thiagomz | how can i trace it.. to identify the SQL that this screen ran... | 05:13 |
thiagomz | printqry ? | 05:13 |
thiagomz | or odbc trace ? | 05:13 |
pboro | I guess ODBC trace could work at least | 05:14 |
pboro | I'm not too familiar with ODBC :) | 05:14 |
thiagomz | are there a way to trace a session on server ? | 05:15 |
pboro | Not that I know of | 05:15 |
thiagomz | :( | 05:20 |
*** Gerhard has joined #ingres | 06:06 | |
*** mull has joined #ingres | 06:08 | |
*** DarylM has joined #ingres | 07:04 | |
*** zxiiro has joined #ingres | 07:09 | |
*** bonro011 has left #ingres | 07:09 | |
*** bonro01 has joined #ingres | 07:10 | |
*** DarylM has quit IRC | 07:36 | |
*** Deyan has joined #ingres | 07:47 | |
Deyan | hello | 07:47 |
*** mull has quit IRC | 07:49 | |
*** DarylM has joined #ingres | 07:49 | |
*** Alex| is now known as Alex|off | 07:54 | |
Deyan | does anyone know if there is luasql module which can work with Ingres? :) | 07:58 |
*** DarylM has quit IRC | 08:20 | |
*** grantc has joined #ingres | 08:23 | |
*** ChanServ sets mode: +o grantc | 08:23 | |
*** mull has joined #ingres | 08:30 | |
*** Gerhard has quit IRC | 08:40 | |
*** Gerhard has joined #ingres | 08:46 | |
*** DerMeister has joined #ingres | 08:55 | |
*** grantc has quit IRC | 09:37 | |
*** Gerhard has quit IRC | 09:56 | |
*** Gerhard has joined #ingres | 09:57 | |
*** Deyan has quit IRC | 09:59 | |
*** Gerhard has quit IRC | 10:12 | |
*** rossand has joined #ingres | 12:12 | |
*** ChanServ sets mode: +o rossand | 12:12 | |
*** Alex|off is now known as Alex| | 12:18 | |
*** rossand has quit IRC | 12:20 | |
*** DarylM has joined #ingres | 12:27 | |
thiagomz | guys, set trace point dm420 | 12:40 |
thiagomz | doesn't work | 12:40 |
thiagomz | why ? | 12:40 |
thiagomz | :) | 12:40 |
DarylM | Always works for me. What version and where are you looking for the results? | 12:44 |
*** satanmalin has quit IRC | 13:56 | |
*** Alex| is now known as Alex|off | 13:59 | |
*** DerMeister has quit IRC | 14:06 | |
*** Alex|off has quit IRC | 14:58 | |
*** Nornagest has quit IRC | 14:58 | |
*** DarylM has quit IRC | 15:35 | |
*** mull has quit IRC | 16:34 | |
*** ii_log has joined #ingres | 17:07 | |
*** rossand has joined #ingres | 17:49 | |
*** ChanServ sets mode: +o rossand | 17:49 | |
*** rossand has quit IRC | 18:01 | |
*** mull has joined #ingres | 18:30 | |
*** zxiiro has quit IRC | 19:00 | |
*** zxiiro has joined #ingres | 19:32 | |
*** thiagomz_ has joined #ingres | 21:10 | |
*** thiagomz has quit IRC | 21:10 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!