| 01:25:53 | *** sunbiz has joined #openmrs |
| 01:26:09 | <sunbiz> !devcall |
| 01:26:09 | <OpenMRSBot> sunbiz: Error: "devcall" is not a valid command. |
| 01:26:34 | *** sunbiz has left #openmrs |
| 05:28:48 | *** TorLye has quit IRC |
| 06:44:34 | *** james_regen has joined #openmrs |
| 06:44:34 | *** ChanServ sets mode: +v james_regen |
| 07:53:43 | *** jmiranda has joined #openmrs |
| 07:53:43 | *** ChanServ sets mode: +o jmiranda |
| 08:44:03 | *** [mharrison] has quit IRC |
| 08:44:09 | *** bwolfe has joined #openmrs |
| 08:44:09 | *** ChanServ sets mode: +o bwolfe |
| 08:45:42 | <nribeka> !conferencecall |
| 08:45:42 | <OpenMRSBot> nribeka: "conferencecall" --- http://openmrs.org/wiki/Developers_Conference_Call |
| 08:53:05 | *** sprasanna has joined #openmrs |
| 08:53:17 | <sprasanna> bwolfe: hi ben |
| 09:02:51 | <bwolfe> hey there sprasanna |
| 09:03:08 | <sprasanna> bwolfe: longtime na... sorry had exams... |
| 09:03:16 | <bwolfe> ah |
| 09:03:28 | <bwolfe> did you pass? are you on break now or were they midterms ? |
| 09:03:30 | <sprasanna> bwolfe: by the way today daniel is getting married. do u know that? |
| 09:03:35 | <bwolfe> what?? |
| 09:03:36 | <bwolfe> no |
| 09:03:42 | <bwolfe> thats nice |
| 09:04:12 | <sprasanna> bwolfe: today had the last exam... just mid terms... |
| 09:04:47 | <bwolfe> sprasanna: and do you think you passed ? |
| 09:05:02 | <sprasanna> bwolfe: i dont think so :P |
| 09:05:30 | <sprasanna> bwolfe: we got this best 2 outta 3 system so can manage easily ;) |
| 09:05:51 | <sprasanna> bwolfe: i performed well in first two so no problem about the third :) |
| 09:05:58 | <bwolfe> ah well good |
| 09:08:08 | <sprasanna> bwolfe: but you guys are lucky you all are in a university without the tension of exams :P |
| 09:13:37 | *** sprasanna_ has joined #openmrs |
| 09:22:04 | *** pearlbear has joined #openmrs |
| 09:22:04 | *** ChanServ sets mode: +v pearlbear |
| 09:31:43 | *** sprasanna has quit IRC |
| 09:53:56 | *** atomicturtle has quit IRC |
| 09:59:17 | <sgrannis> nribeka: u there? |
| 09:59:25 | <nribeka> yes |
| 09:59:28 | <nribeka> i'm here |
| 09:59:35 | <nribeka> on conference call too :) |
| 09:59:47 | <nribeka> hi sgrannis |
| 09:59:52 | <sgrannis> looks like we've got the memory problem fixed? |
| 09:59:58 | <sgrannis> openmrs conference call? |
| 10:00:04 | <nribeka> yes and yes |
| 10:00:08 | <sgrannis> great! |
| 10:00:39 | <sgrannis> well, i'll let you get back to the call .... |
| 10:00:39 | <nribeka> using paging on the hibernate result suppress the memory usage |
| 10:00:48 | <sgrannis> great |
| 10:00:58 | <nribeka> that's fine sgrannis. i'm just listening to everyone here :) |
| 10:01:06 | <sgrannis> was it hibernate ot eh JDBC driver? |
| 10:01:10 | <sgrannis> or the |
| 10:01:26 | <nribeka> hibernate |
| 10:02:31 | <nribeka> actually i already have a hunch this might happen if the record number is large enough |
| 10:02:35 | <nribeka> //TODO: possibility of out of memory exception because all record will be |
| 10:02:35 | <nribeka> // loaded to memory immediately |
| 10:02:59 | <nribeka> from OpenMRSReader class |
| 10:03:04 | *** njero has joined #openmrs |
| 10:03:05 | *** ChanServ sets mode: +v njero |
| 10:04:23 | <nribeka> actually it still has the n + 1 select problem in it |
| 10:05:02 | <nribeka> but when i try to fix it by using join everything went slower than before |
| 10:05:08 | <sgrannis> remind me what the n+1 selection problem is? |
| 10:06:01 | <nribeka> when you select a patient that has addresses field (more than one) |
| 10:06:44 | <nribeka> on a lazy loaded environment, hibernate will issue one query to get one address --> resulting n select query |
| 10:07:04 | <nribeka> and another query to get the patient --> total is n + 1 to get a patient |
| 10:07:57 | <nribeka> read the hibernate in action book to learn about the paging and n + 1 problem :) |
| 10:08:14 | <sgrannis> so you're saying that one patient can have many addresses |
| 10:08:45 | <sgrannis> and to find n addresses for one patient requires n queries? |
| 10:09:02 | <nribeka> yes |
| 10:09:06 | <sgrannis> is there way to optimize that? |
| 10:09:30 | <nribeka> according to the book, we can use join |
| 10:10:08 | <nribeka> but i tried to use join and it took more time than leaving it without using join |