| *** mull_ has quit IRC | 00:16 | |
| *** mull_ has joined #ingres | 02:50 | |
| *** rossand has joined #ingres | 03:05 | |
| *** ChanServ sets mode: +o rossand | 03:05 | |
| *** rossand has quit IRC | 04:08 | |
| *** pleemans has joined #ingres | 06:52 | |
| *** bonro011 has joined #ingres | 07:45 | |
| *** bonro01 has quit IRC | 07:45 | |
| *** Gerhard has joined #ingres | 08:03 | |
| *** withdefault has joined #ingres | 08:11 | |
| *** ChanServ sets mode: +o withdefault | 08:11 | |
| *** [1]Gerhard has joined #ingres | 08:24 | |
| *** Gerhard has quit IRC | 08:37 | |
| *** [1]Gerhard is now known as Gerhard | 08:37 | |
| pboro | hmh... are the patch types explained some where? COMP is one of the types, isn't it? | 09:43 |
|---|---|---|
| pboro | err, I'm not able to download patches from ESD even tho' I do have access to Service Desk... are the patches supposed to be downloadable by customer by default or not? | 10:14 |
| *** crogr01 has joined #ingres | 10:32 | |
| *** ChanServ sets mode: +o crogr01 | 10:32 | |
| *** crogr01 is now known as grantc | 10:32 | |
| grantc | morning all | 10:32 |
| SlimeyPete | ello | 10:34 |
| grantc | how's things going in fortress britain? | 10:36 |
| SlimeyPete | grantc: not bad | 10:53 |
| SlimeyPete | if a bit panicky in this particular office | 10:53 |
| * SlimeyPete snarls at 4GL, which appears to dislike FIRST and ORDER BY RANDOM() even though isql is perfectly happy with it | 10:54 | |
| SlimeyPete | ... but it's perfectly happy to use RANDOM() outside of an sql statement | 10:56 |
| * SlimeyPete shurgs, and just does a massive over-select | 10:57 | |
| grantc | first not supported in abf? | 10:59 |
| grantc | strange | 10:59 |
| SlimeyPete | yeah | 11:00 |
| SlimeyPete | it seems to want to treat it as a field | 11:00 |
| grantc | hmm | 11:04 |
| grantc | for some happy news... | 11:07 |
| *** grantc has quit IRC | 11:07 | |
| *** grantc has joined #ingres | 11:09 | |
| *** ChanServ sets mode: +o grantc | 11:09 | |
| grantc | hmm - ctrl-c in windows irssi not a good move | 11:09 |
| grantc | SlimeyPete: some "good news" for you - http://ingres.pastebin.com/m3d88635d | 11:10 |
| grantc | or http://ingres.pastebin.com/d671e5d77 to see the full code | 11:11 |
| SlimeyPete | that's doing paramaeter subsitution? | 11:13 |
| grantc | yup | 11:18 |
| grantc | with cache_dynamic you should get a speed boost | 11:18 |
| grantc | i.e the server does not need to generate the QEP each time | 11:18 |
| grantc | see http://ingres.pastebin.com/d5654f98f for a select | 11:20 |
| grantc | i need to do some more testing but the bulk of the work is done i believe | 11:20 |
| SlimeyPete | cool | 11:24 |
| grantc | cool | 11:31 |
| *** thiagomz has joined #ingres | 12:37 | |
| withdefault | grantc, cache_dynamic is for select queries only | 12:41 |
| pboro | grantc, btw, about dynamic_cache... is there any limits to the cache size? any way to control the cache other than on/off? | 12:42 |
| *** troal01 has left #ingres | 12:50 | |
| grantc | pboro: I don't know | 12:51 |
| pboro | okay | 12:51 |
| pboro | Just wondering how much memory it will use... | 12:51 |
| withdefault | pboro, config.dat parameter cache_dynamic on/off instance wide, then within a session set [no]cache_dynamic or at a statement level | 12:51 |
| withdefault | prepare xxx from repeat select … | 12:51 |
| withdefault | share objects are stored in QSF like stored procedures | 12:51 |
| grantc | i guess it uses the QEF/QSF mem | 12:51 |
| pboro | ok, so there might be a need to up QEF/QSF mem | 12:52 |
| grantc | withdefault: you have to specify "repeat"? | 12:52 |
| withdefault | only if it's off and you want it for a specific select statement | 12:53 |
| grantc | ta | 12:53 |
| withdefault | I don't know of anyone who is using it at the statement level | 12:53 |
| grantc | that could be useful for the php driver | 12:53 |
| grantc | i am thinking about how it could be enforced - either using 'set session..' or adding 'repeat' | 12:54 |
| grantc | s/enforced/enabled/ | 12:54 |
| *** grantc has quit IRC | 13:04 | |
| *** mull_ has quit IRC | 13:14 | |
| *** thiagomz_ has joined #ingres | 13:15 | |
| thiagomz_ | guys, any recommendation to do a unloaddb over NFS ? Any special option on nfs ? | 13:18 |
| *** rossand has joined #ingres | 13:20 | |
| *** ChanServ sets mode: +o rossand | 13:20 | |
| *** thiagomz has quit IRC | 13:32 | |
| *** mull_ has joined #ingres | 14:12 | |
| *** DarylM has joined #ingres | 14:46 | |
| *** Gerhard has quit IRC | 14:52 | |
| *** crogr01 has joined #ingres | 15:45 | |
| *** crogr01 is now known as grantc | 15:45 | |
| *** ChanServ sets mode: +o grantc | 15:45 | |
| *** DerMeister has joined #ingres | 17:34 | |
| *** withdefault has left #ingres | 18:25 | |
| *** grantc has quit IRC | 18:34 | |
| *** flyer_ has joined #ingres | 18:42 | |
| *** flyer has quit IRC | 18:58 | |
| *** thiagomz_ has quit IRC | 20:48 | |
| *** pleemans has quit IRC | 21:01 | |
| *** DarylM has quit IRC | 22:14 | |
| *** bonro011 has left #ingres | 22:58 | |
| *** DerMeister has quit IRC | 23:13 | |
| *** mull_ has quit IRC | 23:16 | |
| *** SlimeyPete has quit IRC | 23:50 | |
| *** SlimeyPete has joined #ingres | 23:50 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!