The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community

Geekfinder
UFie Gear
Advertise on UF

Forum Rules
& FAQ


Username

Password


Create a New Account

 
 

Back to UserFriendly Strip Comments Index

Alright, I've about had it! by Nessalc 2003-06-06 10:35:54
Though I don't mind being completely unproductive when I "get" to read UF, after 3.5 hours, it gets a bit annoying.

I've got a SQL query that includes a join between a ~1.5 million record table and a ~70,000 record table. Without the join, it takes about .5 seconds. With the join, well, I don't know how long it takes. If it hadn't errored out last night (because I forgot to delete a table), I would know. Somewhere between 3.5 hours and 16.5 hours, anyway... If you've got any ideas, let me know, I'd appreciate it.
[ Reply ]
  The waiting gets annoying by Nessalc2003-06-06 10:36:55
  make sure the join goes the right way... by plblark2003-06-06 10:42:01
    checked those by Nessalc2003-06-06 10:47:51
  Why join? by Frans2003-06-06 10:59:53
    good idea by Nessalc2003-06-06 11:07:28
  Have you checked the indexes by SaleGamine2003-06-06 11:38:58
    I did check them, but after Frans' suggestion, by Nessalc2003-06-06 11:47:43

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)