| munz | how many people die a year on our roadways? | 00:20 |
|---|---|---|
| munz | 37,000+ | 00:20 |
| munz | when you are experiencing heightened stress, emotions or stress the driver should: | 00:48 |
| munz | a)continue as normal | 00:48 |
| munz | b)not drive | 00:48 |
| munz | c)stomp the gas | 00:48 |
| munz | lol | 00:48 |
| munz | me say c)stomp the gas | 00:49 |
| MichelleQ | I vote stomp the gas, and vehemently curse | 01:02 |
| munz | yay! me like big words, i will reuse it asap :) "vehemently" | 01:04 |
| MichelleQ | rofl, you're welcome :-D | 01:06 |
| RoAkSoAx | itnet7: let me know when you around | 02:40 |
| reya276 | Morning Everyone | 14:21 |
| maxolasersquad | Good morning reya276. | 14:28 |
| RoAkSoAx | itnet7: ping | 14:44 |
| dantalizing | morning | 15:08 |
| maxolasersquad | We are having the most frustrating problem. When PHP calls one of our Oracle database packages, a query in the package executes against an execution plan that causes it to take 30 minutes to get the results. | 16:18 |
| maxolasersquad | If we call that package directly in the database, or with Ruby or Python, the query runs in milliseconds. | 16:18 |
| mhall119 | what's a database package? | 16:29 |
| maxolasersquad | mhall119: Oracle has its own language, PL/SQL, which is stored as database objects. A package is a collection of procedures and functions. | 16:30 |
| mhall119 | ah, ok | 16:30 |
| mhall119 | I have no experience with them | 16:30 |
| mhall119 | is it the execution that takes 30 minutes, or is it transfering data from Oracle to PHP? | 16:30 |
| maxolasersquad | We have added a bunch of debugging. It is the execution of the SQL statement. | 16:30 |
| mhall119 | I've noticed that some DB drivers pull data only when needed, while other's load all available data when the query is executed | 16:31 |
| mhall119 | maxolasersquad: the execute command in PHP? or the query processing in Oracle? | 16:31 |
| maxolasersquad | These packages execute on the database. There's no good explenation as to why they would execute differently by who called it. | 16:31 |
| mhall119 | if PHP is reading data while others are not, that might account for it | 16:32 |
| maxolasersquad | PHP does something calls the OCI driver with something like "BEGIN foo.bar(args) END;" | 16:32 |
| maxolasersquad | We capture, in the procedure, the time it was called, and with what parameters, and the time that different points of the code are executing. | 16:33 |
| maxolasersquad | So we can see that execution of the SQL query taking a long time, but once it is done, PHP gets the results and processes them quickly. | 16:34 |
| maxolasersquad | However, if we call that same package with the OCI drivers for Ruby or Python, that query executes really fast. | 16:34 |
| maxolasersquad | It's rather frustrating. | 16:34 |
| maxolasersquad | We keep making small changes to the query, and that fixes it, but any time a small dependency changes, the query goes to poop, and we have to play some more. | 16:35 |
| maxolasersquad | We've decided if we ever get stuck, we will have PHP call Ruby, which will call the package, and send the results up the chain. | 16:37 |
| mhall119 | lol | 16:40 |
| itnet7 | RoAkSoAx: ping | 17:52 |
| RoAkSoAx | itnet7: pong | 18:01 |
| DammitJim | can someone help me with java basics on negative numbers? | 19:05 |
| mhall119 | what's to know? | 19:17 |
| DammitJim | I'm so confused about the simplicity of negative numbers | 19:18 |
| DammitJim | I'm reading a register from a radio and it gives me 0xFFAB | 19:18 |
| DammitJim | that's -55 in decimal | 19:18 |
| DammitJim | so, my question is... can I do regular arithmetic with this short? | 19:19 |
| mhall119 | as far as I know | 19:28 |
| DammitJim | darnet... it seems I need to sign extend it | 19:38 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!