[00:20] how many people die a year on our roadways? [00:20] 37,000+ [00:48] when you are experiencing heightened stress, emotions or stress the driver should: [00:48] a)continue as normal [00:48] b)not drive [00:48] c)stomp the gas [00:48] lol [00:49] me say c)stomp the gas [01:02] I vote stomp the gas, and vehemently curse [01:04] yay! me like big words, i will reuse it asap :) "vehemently" [01:06] rofl, you're welcome :-D [02:40] itnet7: let me know when you around [14:21] Morning Everyone [14:28] Good morning reya276. [14:44] itnet7: ping [15:08] morning [16:18] 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] If we call that package directly in the database, or with Ruby or Python, the query runs in milliseconds. [16:29] what's a database package? [16:30] 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] ah, ok [16:30] I have no experience with them [16:30] is it the execution that takes 30 minutes, or is it transfering data from Oracle to PHP? [16:30] We have added a bunch of debugging. It is the execution of the SQL statement. [16:31] 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] maxolasersquad: the execute command in PHP? or the query processing in Oracle? [16:31] These packages execute on the database. There's no good explenation as to why they would execute differently by who called it. [16:32] if PHP is reading data while others are not, that might account for it [16:32] PHP does something calls the OCI driver with something like "BEGIN foo.bar(args) END;" [16:33] 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:34] 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] However, if we call that same package with the OCI drivers for Ruby or Python, that query executes really fast. [16:34] It's rather frustrating. [16:35] 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:37] 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:40] lol [17:52] RoAkSoAx: ping [18:01] itnet7: pong [19:05] can someone help me with java basics on negative numbers? [19:17] what's to know? [19:18] I'm so confused about the simplicity of negative numbers [19:18] I'm reading a register from a radio and it gives me 0xFFAB [19:18] that's -55 in decimal [19:19] so, my question is... can I do regular arithmetic with this short? [19:28] as far as I know [19:38] darnet... it seems I need to sign extend it