Non-mobile site
Features currently not on the mobile site: search, favorite links, and fake quotes
 
Home Store
 <|First  <Previous Comic Next Comic>  Last|>
Insert it all
2012-04-11
Remove R Comic (aka rm -r comic), by Gary Marks:Insert it all Dialog: You want a hard drive? I'll show you a hard drive, North Yungas Road. Panel 1 Sally: Hey, what's the most data we can load into our database in a single insert? Panel 2 Jase: I wouldn't worry about it, our servers are state of the art, they're limitless. Panel 3 Sally: Excellent! Then could you load this for me? Jase: A hard drive? Panel 4 Sally: No. It's my sql statement. Well, it's most of it. Jase: But it's a 3TB hard drive. Sally: Yeah, I know. I couldn't find anything larger. Don't worry though, I'll get you the second drive tomorrow.


689
 <|First  <Previous Comic Next Comic>  Last|>

Comic dialog
You want a hard drive? I'll show you a hard drive, North Yungas Road.

Panel 1
Sally: Hey, what's the most data we can load into our database in a single insert?
Panel 2
Jase: I wouldn't worry about it, our servers are state of the art, they're limitless.
Panel 3
Sally: Excellent! Then could you load this for me?
Jase: A hard drive?
Panel 4
Sally: No. It's my sql statement. Well, it's most of it.
Jase: But it's a 3TB hard drive.
Sally: Yeah, I know. I couldn't find anything larger. Don't worry though, I'll get you the second drive tomorrow.

Gary
Author Comments aka Comic News


The first thing to learn, if you're in the technical field, is, "there are always limits", and if anyone ever tells you something has no limit, they're lying. So, I'm loading a lot of data into my database for the contest. Basically, I'm entering in each kill that takes place, so I can put up a page with the scores (soon). Now I run on a shared server, so I don't want to mess up performance for others on my server, so I asked them what size of bulk insert I should do (it's a manual process because I can't remotely insert), and the response I got back was, "There is no such limit for group of values". Sadly, I know that A. there is an actual limit in the db, and B. before the database limit, there is a performance limit. This is what I get for trying to be nice. It's ok, I broke it down as much as I could, hopefully it's enough.
RIP rm-r-comic
Apr 2 2007->Oct 31 2015

<   April 2012   >
Sun Mon Tue Wed Thu Fri Sat
1 2 3 4 5 6 7
8 9 10   11  12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30