| *** magnusg| has joined #ingres | 00:04 | |
| *** grantc has joined #ingres | 00:19 | |
| *** ChanServ sets mode: +o grantc | 00:19 | |
| *** ii_log` is now known as ii_log | 00:42 | |
| *** Deyan has joined #ingres | 01:04 | |
| Deyan | good morning peeps | 01:05 |
|---|---|---|
| pboro | 'ing | 01:05 |
| * Deyan got his Ingres T-Shirt! \o/ | 01:06 | |
| Deyan | it is AWESOME | 01:06 |
| pboro | from zazzle? | 01:07 |
| Deyan | yeah | 01:07 |
| Deyan | the one i designed | 01:07 |
| Deyan | it is really nice | 01:07 |
| pboro | yup | 01:07 |
| grantc | morning | 01:14 |
| *** ingres has joined #ingres | 01:19 | |
| Deyan | ingres: :D | 01:23 |
| *** ingres has quit IRC | 01:26 | |
| *** dyki has joined #ingres | 01:27 | |
| *** Deyan has quit IRC | 02:41 | |
| *** Nornagest has quit IRC | 03:05 | |
| *** Alex|off has quit IRC | 03:05 | |
| *** Alex| has joined #ingres | 03:06 | |
| *** ChanServ sets mode: +o Alex| | 03:06 | |
| *** Nornagest has joined #ingres | 03:07 | |
| *** Alex| is now known as Alex|off | 03:08 | |
| *** Alex|off is now known as Alex| | 03:09 | |
| *** Deyan has joined #ingres | 03:51 | |
| Deyan | hello guys | 03:51 |
| Deyan | guys a short question: how to get the time needed to process a certain query? | 03:51 |
| Deyan | i want to compare how fast/slow our new server/database is comparing to the old one | 03:52 |
| Deyan | and i want to run a particularly slow query | 03:52 |
| Deyan | (needs around 10sec to finish) | 03:52 |
| grantc | take a timestamp before and after and execute | 04:08 |
| magnusg| | Deyan, there's an old method for statement benchmark containing these steps: | 04:18 |
| magnusg| | Flush the cash | 04:18 |
| magnusg| | set trace point dm421; | 04:19 |
| magnusg| | select dbmsinfo(‘_cpu_ms') as cpu; select dbmsinfo(‘_et_sec') as time; select dbmsinfo(‘_dio_cnt') as dio; | 04:20 |
| magnusg| | run query and repeat the dbmsinfo queries and calculate how long your query has taken to execute. | 04:21 |
| Deyan | i get crazy char | 04:45 |
| Deyan | is it dbmsinfo('a_cpu_ms') ? | 04:45 |
| Deyan | < magnusg|> select dbmsinfo(â_cpu_ms') | 04:50 |
| Deyan | this is what i got | 04:50 |
| *** atrofast has joined #ingres | 04:57 | |
| magnusg| | Deyan, it should be dbmsinfo('_cpu_ms'). I had problems with the copy/paste and failed to proofread enough. | 05:01 |
| magnusg| | No, it looked ok om my screen. I don't see any a-letter before _cpu_ms. | 05:02 |
| grantc | magnusg|, there appears to be a different quote char at the start of the string | 05:03 |
| magnusg| | grantc, I realize that. I copied from a ppt via Word and this web-browser and something must have happened on the way. | 05:07 |
| grantc | i thought MS would be involved somewhere | 05:07 |
| atrofast | Isn't MS always involved? :P | 05:08 |
| grantc | welcome back atrofast - how was your vacation? | 05:10 |
| atrofast | Thanks grantc, it was really good, although too short ;) | 05:10 |
| grantc | as always :) | 05:10 |
| *** Alex| is now known as Alex|off | 05:25 | |
| Deyan | yeah | 05:57 |
| Deyan | i hope you had a good time, atrofast | 05:57 |
| *** Alex|off is now known as Alex| | 05:57 | |
| atrofast | Thanks Deyan, I did... We went to Florida for a few days :) | 05:58 |
| *** DarylM has joined #ingres | 06:25 | |
| *** magnusg| has quit IRC | 07:10 | |
| *** mull has joined #ingres | 07:14 | |
| *** cthibert has joined #ingres | 07:49 | |
| *** zxiiro_ has joined #ingres | 08:21 | |
| *** zxiiro has quit IRC | 08:21 | |
| *** zxiiro_ is now known as zxiiro | 08:21 | |
| *** ChanServ sets mode: +v zxiiro | 08:21 | |
| *** rossand has joined #ingres | 09:10 | |
| *** ChanServ sets mode: +o rossand | 09:10 | |
| grantc | atrofast, have there been any changes on bugs recently? | 09:33 |
| atrofast | Only one, I installed a plugin at clach04's request | 09:34 |
| atrofast | Did it cause any issues? | 09:34 |
| atrofast | Yeah it did okay looking into it | 09:34 |
| grantc | ta | 09:36 |
| atrofast | Okay fixed | 09:41 |
| atrofast | Do you want me to reply to the email or do you want the honour? :) | 09:43 |
| *** rossand has quit IRC | 09:51 | |
| *** grantc has quit IRC | 09:56 | |
| Deyan | see you tomorrow guys | 10:04 |
| Deyan | time to go home | 10:04 |
| *** Deyan has quit IRC | 10:05 | |
| *** rossand has joined #ingres | 10:12 | |
| *** ChanServ sets mode: +o rossand | 10:12 | |
| *** rossand has quit IRC | 10:30 | |
| *** Alex| is now known as Alex|off | 12:49 | |
| *** DerMeister has joined #ingres | 13:01 | |
| *** ii_log` has joined #ingres | 13:09 | |
| *** ii_log has quit IRC | 13:09 | |
| *** zxiiro has quit IRC | 13:09 | |
| *** zxiiro has joined #ingres | 13:09 | |
| *** ChanServ sets mode: +v zxiiro | 13:09 | |
| *** rossand has joined #ingres | 13:55 | |
| *** ChanServ sets mode: +o rossand | 13:55 | |
| *** rossand has quit IRC | 14:27 | |
| *** cthibert has left #ingres | 14:53 | |
| *** DerMeister has quit IRC | 15:01 | |
| *** DarylM has quit IRC | 15:22 | |
| *** mull has quit IRC | 16:21 | |
| *** mull has joined #ingres | 17:17 | |
| *** grantc has joined #ingres | 22:27 | |
| *** ChanServ sets mode: +o grantc | 22:27 | |
| *** Alex|off is now known as Alex| | 22:39 | |
| *** Alex| is now known as Alex|off | 23:09 | |
| *** magnusg| has joined #ingres | 23:25 | |
| *** Alex|off is now known as Alex| | 23:27 | |
| *** ii_log` is now known as ii_log | 23:40 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!