| *** 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!