02:44.56 | *** join/#wowroster [PUPPETS]Gonzo (i=gonzo@80.69.47.16) [NETSPLIT VICTIM] |
02:45.43 | *** join/#wowroster poetter (n=poetter@e177175107.adsl.alicedsl.de) |
02:49.53 | *** join/#wowroster dracula (i=dracula@dhcp-077-251-023-107.chello.nl) [NETSPLIT VICTIM] |
02:49.57 | *** join/#wowroster Zeryl (n=Zeryl@24-178-44-20.dhcp.sprt.il.charter.com) [NETSPLIT VICTIM] |
02:49.57 | *** join/#wowroster fewyn (n=fewyn@46.210.33.65.cfl.res.rr.com) [NETSPLIT VICTIM] |
02:49.57 | *** mode/#wowroster [+o Zeryl] by irc.freenode.net |
02:51.17 | *** join/#wowroster [PUPPETS]Gonzo (i=gonzo@80.69.47.16) [NETSPLIT VICTIM] |
07:20.24 | *** join/#wowroster PleegWat|Work (n=ple@82-148-206-57.fiber.unet.nl) |
07:20.24 | *** mode/#wowroster [+o PleegWat|Work] by ChanServ |
07:33.15 | *** join/#wowroster Tupsi (n=Miranda@217.7.101.202) |
11:59.08 | *** join/#wowroster apt (i=ibot@pdpc/supporter/active/TimRiker/bot/apt) |
11:59.08 | *** topic/#wowroster is UPDATE: Check WowRoster.net for updates | Roster 2.0 beta1 Released! | This room is for the support of WoWRoster.net only [R-v1.7.3, UU-v2.6.7, jUU-v0.9.15, UA-v0.7.9] | The devs have lives, they're not monitoring 24/7 | Troubles registering/viewing our site? Check here-> http://www.wowroster.net/Forums/viewtopic/t=15.html |
12:11.51 | *** join/#wowroster Theophilius (n=Theophil@LAubervilliers-153-53-2-230.w193-252.abo.wanadoo.fr) |
12:12.02 | Theophilius | Hi all |
12:47.42 | *** join/#wowroster fewyn[sleep] (n=fewyn@46.210.33.65.cfl.res.rr.com) |
14:33.45 | *** join/#wowroster Nefuh (n=nefuh@dslb-084-062-243-067.pools.arcor-ip.net) |
15:15.04 | *** join/#wowroster Nefuh|away (n=nefuh@dslb-084-062-254-236.pools.arcor-ip.net) |
16:21.08 | *** join/#wowroster Zanix|Work (n=Zanix@71.216.154.51) |
16:21.08 | *** mode/#wowroster [+o Zanix|Work] by ChanServ |
19:10.00 | *** join/#wowroster Tupsi (n=Miranda@pD95FC9B5.dip.t-dialin.net) |
20:54.36 | *** join/#wowroster Gaxme (n=chatzill@64.247.200.42) |
20:54.49 | Gaxme | Heya. |
20:55.07 | Gaxme | Random question of the moment: Do I need to free the result of a insert query? |
20:55.08 | Zanix|Work | hi |
20:55.16 | Zanix|Work | no, only select |
20:55.26 | Zanix|Work | otherwise you get a sql error |
20:55.40 | Zanix|Work | there are other instances where you hsould free it |
20:55.45 | Gaxme | That explains where those were coming from. =) |
20:55.46 | Zanix|Work | but I cant recall at the moment |
20:58.39 | PleegWat | try a var_dump of the result of an insert |
20:58.49 | PleegWat | It doesn't return mysql_result - just boolean |
20:59.10 | Gaxme | *nod |
20:59.22 | Gaxme | Something I'm doing is breaking the footer, I need to figure out what that is as well. |
21:00.34 | Gaxme | Unless... The footer is supposed to show up on the update page after sending data, correct? Nevermind, dumb question. |
21:00.40 | Gaxme | It shows sql queries and such usually. |
21:00.53 | Gaxme | I have somehow busted it. Heh. |
21:01.15 | PleegWat | Are you doing something fatal? Check your error log |
21:04.43 | Gaxme | Yep, memory exhaustion. |
21:04.45 | Gaxme | Bah. |
21:05.27 | Gaxme | The script itself is pulling 32meg. |
21:05.31 | Gaxme | I have my limit set to 50. |
21:05.45 | Gaxme | That's a lot of processing memory for a 3.1 meg lua file. |
21:05.56 | Gaxme | Of course, it's also processing everything it can. |
21:06.11 | Gaxme | I need to add in a flag for per-loot attendance and per-boss attendance. |
21:06.35 | PleegWat | There's a factor 5 expansion just from php array overhead |
21:07.31 | PleegWat | For memory usage, best chance is probably inserting stuff into DB right away then do the rest in sql |
21:09.14 | Gaxme | Hmm. I've never tried that. You mean actually taking all the data from the lua and dumping it to a temporary table first? |
21:09.21 | Gaxme | Then collating it out from there? |
21:09.40 | Gaxme | Hard for me to believe that SQL overhead is less than php. Heh. |
21:09.50 | PleegWat | sql overhead doesn't count to php memory |
21:09.57 | PleegWat | and sql's better at structured bulk data |
21:10.41 | Gaxme | Hmm. Can you point me in the direction of an example of that method? |
21:11.02 | PleegWat | not really. I do keys processing in DB, but that's something else entirely. |
21:11.07 | Gaxme | Right now it takes the LUA file and splits the parsing sections into separate functions. |
21:11.24 | Gaxme | Some of them are more intensive than others. |
21:11.48 | PleegWat | Are you cleaning up redundant php-side memory sufficiently? |
21:11.52 | Gaxme | Items, specifically, since it iterates through the items, then calls out per item to 1) record the item, 2) record the members who were there when it dropped |
21:12.05 | Gaxme | Probably not. |
21:12.22 | Gaxme | I don't think I'm a supercoder by any stretch of imagination. |
21:12.26 | PleegWat | Not writing to pass-by-value function parameter structs? |
21:13.29 | Gaxme | Hell, I completely forgot about that. |
21:17.03 | Gaxme | Let's see what that does. |
21:18.19 | PleegWat | If you're only using local temp variables for the full duration of a function, you should be fine. |
21:18.42 | PleegWat | But if you're stuffing in a lot of data, and you're not using it for the full duration of the function, or it's not local, unset it when you don't use it anymore. |
21:18.45 | PleegWat | Same goes for subarrays. |
21:19.27 | Gaxme | So things like foreach loops with variables should be unset at the end. |
21:19.57 | Gaxme | foreach( $array_values as $name ) { } make sure and unset($name); ? |
21:20.03 | PleegWat | yes |
21:20.21 | Gaxme | Can you set by reference also? |
21:20.33 | PleegWat | Or use foreach( $array_values as &$name ) {} |
21:20.40 | Gaxme | eg: I've got a global variable set at the top. |
21:21.07 | Gaxme | Can you do &$this->variable = value; ? |
21:21.17 | Gaxme | Or does that matter? |
21:24.17 | Gaxme | Fatal error: Cannot create references to elements of a temporary array expression |
21:24.17 | Gaxme | Boo! |
21:24.43 | Gaxme | That's using foreach( $array_values as &$name ) {} |
21:25.48 | *** join/#wowroster PleegWat_ (n=PleegWat@212-123-189-114.ip.telfort.nl) |
21:25.48 | *** mode/#wowroster [+o PleegWat_] by ChanServ |
21:29.45 | Zanix|Work | which php version do you have |
21:38.08 | Gaxme | 5.1.6 currently |
21:59.27 | Gaxme | Gotta run, some prep to do to keep myself in wifely good graces. |