[00:20] <munz> how many people die a year on our roadways?
[00:20] <munz> 37,000+
[00:48] <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:49] <munz> me say c)stomp the gas
[01:02] <MichelleQ> I vote stomp the gas, and vehemently curse
[01:04] <munz> yay! me like big words, i will reuse it asap :) "vehemently"
[01:06] <MichelleQ> rofl, you're welcome :-D
[02:40] <RoAkSoAx> itnet7: let me know when you around
[14:21] <reya276> Morning Everyone
[14:28] <maxolasersquad> Good morning reya276.
[14:44] <RoAkSoAx> itnet7: ping
[15:08] <dantalizing> morning
[16:18] <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:29] <mhall119> what's a database package?
[16:30] <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:31] <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:32] <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:33] <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:34] <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:35] <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:37] <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:40] <mhall119> lol
[17:52] <itnet7> RoAkSoAx: ping
[18:01] <RoAkSoAx> itnet7: pong
[19:05] <DammitJim> can someone help me with java basics on negative numbers?
[19:17] <mhall119> what's to know?
[19:18] <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:19] <DammitJim> so, my question is... can I do regular arithmetic with this short?
[19:28] <mhall119> as far as I know
[19:38] <DammitJim> darnet... it seems I need to sign extend it