important SQL safety tip

May. 30th, 2005 07:39 pm
acroyear: (geek2)
[personal profile] acroyear
if you remove a reference/join to a table of some 65,000 records in a WHERE clause, its usually a very good idea to remove it from the FROM clause as well...
Tags:
  • Add Memory
  • Share This Entry
Flat | Top-Level Comments Only

Date: 2005-05-31 10:57 am (UTC)
From: [identity profile] kowari.livejournal.com
*point and laugh!*
*frowns... thinks*
*shakes head in own disbelief*
  • Add Memory
  • Share This Entry
Flat | Top-Level Comments Only

Profile

acroyear: (Default)
Joe's Ancient Jottings
Joe's Home Page

January 2025

S M T W T F S
   1234
56789 1011
12131415161718
19202122232425
262728293031 

Most Popular Tags

Page Summary

Style Credit

Expand Cut Tags

No cut tags
Page generated Jan. 28th, 2026 03:02 pm
Powered by Dreamwidth Studios