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