| 00:02.22 | *** join/#uphpu bbankes (~bbankes@2601:680:c402:3225:a52e:d976:e74b:3702) |
| 02:33.03 | *** join/#uphpu josephscott (~josephsco@192.0.125.251) |
| 04:12.15 | *** join/#uphpu ninnypants (~ninnypant@unaffiliated/ninnypants) |
| 04:12.15 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 04:27.01 | *** join/#uphpu clintberry (~clintberr@170-72-15-42.ut.vivintwireless.net) |
| 04:27.01 | *** mode/#UPHPU [+v clintberry] by ChanServ |
| 07:41.34 | *** join/#uphpu mgeary_ (~mgeary@75-144-8-210-utah.hfc.comcastbusiness.net) |
| 07:41.34 | *** mode/#UPHPU [+v mgeary_] by ChanServ |
| 07:44.14 | *** join/#uphpu DexterTheDragon (~DexterThe@oalug/member/blackchaos) |
| 07:44.14 | *** mode/#UPHPU [+v DexterTheDragon] by ChanServ |
| 15:34.23 | *** join/#uphpu josephscott (~josephsco@192.0.125.251) |
| 15:36.30 | *** join/#uphpu Heartsbane (tsharpe@shell.xmission.com) |
| 15:36.30 | *** join/#uphpu Heartsbane (tsharpe@unaffiliated/heartsbane) |
| 15:36.30 | *** mode/#UPHPU [+v Heartsbane] by ChanServ |
| 15:38.58 | *** join/#uphpu clintberry (~clintberr@205.197.215.90) |
| 15:38.58 | *** mode/#UPHPU [+v clintberry] by ChanServ |
| 15:40.17 | *** join/#uphpu clintberry (~clintberr@205.197.215.90) |
| 15:40.17 | *** mode/#UPHPU [+v clintberry] by ChanServ |
| 15:43.57 | *** join/#uphpu eggyknap (~jtolley@50.109.209.41) |
| 15:43.57 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 15:43.57 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 16:03.28 | *** join/#uphpu stevecoug (~stevecoug@c-24-11-99-247.hsd1.ut.comcast.net) |
| 16:03.35 | *** join/#uphpu stevecoug (~stevecoug@oalug/member/stevecoug) |
| 16:03.35 | *** mode/#UPHPU [+v stevecoug] by ChanServ |
| 16:14.13 | *** join/#uphpu jnbek_ (~jnbek@pdpc/supporter/active/jnbek) |
| 16:14.13 | *** mode/#UPHPU [+v jnbek_] by ChanServ |
| 16:19.56 | *** join/#uphpu cro (~cro@204.228.149.217) |
| 16:19.58 | *** join/#uphpu ninnypants (~ninnypant@unaffiliated/ninnypants) |
| 16:19.58 | *** mode/#UPHPU [+v ninnypants] by ChanServ |
| 18:30.56 | *** join/#uphpu bbankes (~bbankes@2601:680:c402:3225:803d:2666:5cbf:eae2) |
| 18:31.47 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 18:31.47 | *** mode/#UPHPU [+v jnbek] by ChanServ |
| 18:32.02 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 18:32.02 | *** mode/#UPHPU [+v jnbek] by ChanServ |
| 19:12.32 | *** join/#uphpu eggyknap (~jtolley@unaffiliated/eggyknap) |
| 19:12.32 | *** mode/#UPHPU [+v eggyknap] by ChanServ |
| 20:40.58 | *** join/#uphpu JacobEdmondKerr (~JacobEdmo@50-192-200-9-static.hfc.comcastbusiness.net) |
| 20:42.42 | JacobEdmondKerr | Hey guys I built a script that goes through thousands of MLS listings and checks if it is in our database if not it inserts. If it is instead of me checking if it needs to be updated I just update it. I was advised that this was the best way to do it. But I was on the phone with our server guy the other day and he made me look like an idiot! I checked into this before I did it what do you think?? |
| 21:02.52 | unum | how did he sugges you do it? |
| 21:02.58 | unum | suggest |
| 21:07.22 | JacobEdmondKerr | He suggested that I do a select to see if the data needs to be updated then update if so. Or pull modified date but I am noticing some MLS do not offer a modified date. |
| 21:09.49 | JacobEdmondKerr | If the dates dont match what I have saved then update. I have read that MySQL does not use resources if you send it the same exact data it quickly notices the data is the same and does nothing. Also I have read that checking if the data needs to be updated requires more queries and more resources am I wrong about this? The thing is the queries are remote so they are using bandwidth... |
| 21:39.28 | unum | I don't know the details if mysql that well |
| 22:02.59 | *** join/#uphpu stevecoug (~stevecoug@oalug/member/stevecoug) |
| 22:02.59 | *** mode/#UPHPU [+v stevecoug] by ChanServ |
| 22:56.49 | *** join/#uphpu stderr2 (~stderr@truedat.org) |