User not logged in - login - register
Home Calendar Books School Tool Photo Gallery Message Boards Users Statistics Advertise Site Info
go to bottom | |
 Message Boards » » the problem with 81gb databases: Page [1]  
evan
All American
27701 Posts
user info
edit post

it takes a fucking hour to run an ALTER TABLE statement.



sitting here waiting for this to finish....

6/2/2008 5:19:17 AM

drunknloaded
Suspended
147487 Posts
user info
edit post

yo man so this luis guiterez guy out of illinois i believe went to china and they say the chinks may have copied his laptop harddrive...said they have devices that can do it in minutes...wtf dude it took me like 6 hours to transfer like 6gb through usb

6/2/2008 5:20:17 AM

evan
All American
27701 Posts
user info
edit post

its limited by transfer speed

eide is 133mbps

sata is 300mbps

do the math yourself

the dude is lying.

15 minutes, maybe

6/2/2008 5:28:43 AM

drunknloaded
Suspended
147487 Posts
user info
edit post

http://news.yahoo.com/s/ap/20080529/ap_on_go_ca_st_pe/china_hacking;_ylt=As5uq6tUek7O8PYVdwqJ0YWs0NUE

hmmm...says just minutes...

[Edited on June 2, 2008 at 5:30 AM. Reason : oh carlos guiterez...totally different guy anyways]

6/2/2008 5:30:28 AM

evan
All American
27701 Posts
user info
edit post

well idk

all i know is that you can't change the fact that sata is either 150 or 300mbps and eide is 133mbps.

6/2/2008 5:36:33 AM

DPK
All American
2390 Posts
user info
edit post

What the hell is in that database? lol

6/2/2008 5:42:17 AM

evan
All American
27701 Posts
user info
edit post

it's our department's system inventory database

6/2/2008 5:48:19 AM

DPK
All American
2390 Posts
user info
edit post

Lies, it's your porn database.

6/2/2008 5:53:33 AM

evan
All American
27701 Posts
user info
edit post

damn, you caught me :\

that's the only thing blobs are good for dontchaknow

6/2/2008 5:55:05 AM

evan
All American
27701 Posts
user info
edit post

the biggest problem is the audit table

we track every single change made to the db
there are over 10 million rows in that table alone

6/2/2008 6:10:56 AM

pilgrimshoes
Suspended
63151 Posts
user info
edit post

Meh.

6/2/2008 7:05:13 AM

evan
All American
27701 Posts
user info
edit post

it finally finished

woooo

and everything works properly too

Quote :
"Query OK, 2033745 rows affected (1 hour 29 min 44.84 sec)"




[/thread]

6/2/2008 7:50:10 AM

ScHpEnXeL
Suspended
32613 Posts
user info
edit post

daamn

6/2/2008 8:01:56 AM

qntmfred
retired
40700 Posts
user info
edit post

2 million rows, that's it?

6/2/2008 8:05:23 AM

ScHpEnXeL
Suspended
32613 Posts
user info
edit post

MY E-PENIS IS HUUUGE

Quote :
"Flood control has been activated.
Please wait several minutes to post this message."


dear qntmfred, make this shit chill out

6/2/2008 8:08:59 AM

Rat
Suspended
5724 Posts
user info
edit post

i know a solution for you that would probably take <5 minutes

6/2/2008 8:27:17 AM

tsavla
All American
6787 Posts
user info
edit post

http://www.netezza.com

6/2/2008 8:28:17 AM

evan
All American
27701 Posts
user info
edit post

^do you not know where i work? we are a major BI company, lol

6/2/2008 8:31:12 AM

tsavla
All American
6787 Posts
user info
edit post

i though you lived/worked from your parents basement

6/2/2008 8:32:54 AM

jackleg
All American
170957 Posts
user info
edit post

yeah.. you guys can bust on evan all you want, but when it comes to jobs...

its pretty much safe to say that 98% of you couldn't get a 15 minute quiz interview over the phone for his company.

6/2/2008 8:38:42 AM

qntmfred
retired
40700 Posts
user info
edit post

6/2/2008 8:50:52 AM

jackleg
All American
170957 Posts
user info
edit post

you'd get in qfred. not dissin any of the megaleets like dr havoc

or anyone at like cisco or sun

6/2/2008 8:58:49 AM

evan
All American
27701 Posts
user info
edit post

^tr00f

6/2/2008 9:00:40 AM

jackleg
All American
170957 Posts
user info
edit post

or any of the huge wireless technology companies based here in greensboro, those leet motherfuckers could probably.... hack it... too

6/2/2008 9:01:57 AM

tsavla
All American
6787 Posts
user info
edit post

dint qfred work at some financial firm in charlotte?

6/2/2008 9:03:22 AM

jackleg
All American
170957 Posts
user info
edit post

im really not sure

i know where a few people here work, but never talk about where. i knew evan was at cisco but didnt say anything till i saw him mentioning buildings there and stuff. so figured he didnt care

but not a big fan of mixing career and tww at all, so i wouldnt tell anyone elses job

6/2/2008 9:06:48 AM

evan
All American
27701 Posts
user info
edit post

^you mean sas?

[Edited on June 2, 2008 at 9:08 AM. Reason : although i wouldn't mind working at cisco either]

6/2/2008 9:07:30 AM

qntmfred
retired
40700 Posts
user info
edit post

i worked for a financial services startup

now i work for a different financial services startup

i don't see myself working at any company that big. i don't have the attention span for waterfall

[Edited on June 2, 2008 at 9:10 AM. Reason : agile ftw]

6/2/2008 9:09:45 AM

jackleg
All American
170957 Posts
user info
edit post

yeah i meant sas, i had cisco on the brain thinking about a couple other people on here.

something you said tipped me off before, then you were talking about building T one day and i figured you didnt care if people knew where you worked.

6/2/2008 9:10:33 AM

tsavla
All American
6787 Posts
user info
edit post

message_topic.aspx?topic=486026

6/2/2008 9:11:04 AM

 Message Boards » Chit Chat » the problem with 81gb databases: Page [1]  
go to top | |
Admin Options : move topic | lock topic

© 2024 by The Wolf Web - All Rights Reserved.
The material located at this site is not endorsed, sponsored or provided by or on behalf of North Carolina State University.
Powered by CrazyWeb v2.39 - our disclaimer.