Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.freenet.ag!news2.euro.net!newsgate.cistron.nl!newsgate.news.xs4all.nl!194.109.133.83.MISMATCH!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.015 X-Spam-Evidence: '*H*': 0.97; '*S*': 0.00; 'string.': 0.04; 'context': 0.05; 'paths': 0.05; 'plenty': 0.07; 'table.': 0.07; 'subject:method': 0.09; 'index': 0.13; '4-digit': 0.16; 'equation.': 0.16; 'from:addr:torriem': 0.16; 'from:name:michael torrie': 0.16; 'index.': 0.16; 'infinitely': 0.16; 'string': 0.17; 'wrote:': 0.17; 'fix': 0.17; 'certainly': 0.17; 'subject:page': 0.17; 'code,': 0.18; 'absolute': 0.23; 'errors': 0.23; 'tables': 0.23; "i've": 0.23; 'header:In-Reply-To:1': 0.25; 'header:User- Agent:1': 0.26; 'am,': 0.27; "doesn't": 0.28; 'source': 0.29; 'query': 0.30; 'point': 0.31; 'you?': 0.32; 'space,': 0.32; "who's": 0.32; 'subject: .': 0.33; 'to:addr:python-list': 0.33; 'another': 0.33; 'done': 0.34; 'especially': 0.35; "won't": 0.35; 'there': 0.35; 'received:org': 0.36; 'but': 0.36; 'message- id:@gmail.com': 0.36; 'thank': 0.36; 'data': 0.37; 'subject:: ': 0.38; 'easier': 0.38; 'some': 0.38; 'to:addr:python.org': 0.39; 'received:192': 0.39; 'space': 0.39; 'received:192.168': 0.40; 'header:Received:5': 0.40; 'help': 0.40; 'your': 0.60; 'share': 0.61; 'identify': 0.61; 'between': 0.63; 'harder': 0.65; 'virtually': 0.65; 'million': 0.72; 'hand': 0.82; 'me!': 0.84; 'quota,': 0.84; "site's": 0.84; 'subject:Using': 0.84; 'why?': 0.84; 'hand,': 0.97 X-Virus-Scanned: amavisd-new at torriefamily.org Date: Tue, 22 Jan 2013 11:43:53 -0700 From: Michael Torrie User-Agent: Mozilla/5.0 (X11; Linux i686; rv:10.0.11) Gecko/20121115 Thunderbird/10.0.11 MIME-Version: 1.0 To: python-list@python.org Subject: Re: Using filepath method to identify an .html page References: <50fe787e$0$30003$c3e8da3$5496439d@news.astraweb.com> <50fe8e69$0$30003$c3e8da3$5496439d@news.astraweb.com> <0459659d-4ec2-4c7d-bee3-b4e363c916dd@googlegroups.com> <9d89d978-e570-4b2c-a18e-58d86c35dd4c@googlegroups.com> In-Reply-To: Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 34 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1358880240 news.xs4all.nl 6928 [2001:888:2000:d::a6]:52169 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:37331 On 01/22/2013 11:13 AM, Ferrous Cranus wrote: > a) I'am a reseller, i have unlimited ftp quota, hence database space Space doesn't even come into the equation. There's virtually no difference between a 4-digit number and a 100-character string. Yes there is an absolute difference in storage space, but the difference is so miniscule that there's no point even thinking about it. Especially if you are dealing with less than a million database rows. > b) I'am feeling compelled to do it this way Why? Who's compelling you? Your boss? > c) i DO NOT want to use BIG absolute paths to identify files, just > small numbers , shich they are easier to maintain. No it won't be easier to maintain. I've done my share of web development over the years. There's no difference between using a string index and some form of number index. And if you have to go over the database by hand, having a string is infinitely easier for your brain to comprehend than a magic number. Now don't get me wrong. I've done plenty of tables linked by index numbers, but it's certainly harder to fix the data by hand since an index number only has meaning in the context of a query with another table. > > Your solution i know it works and i thank you very much for > providing it to me! > > Can you help please on the errors that http://superhost.gr gives? Sorry I cannot, since I don't have access to your site's source code, or your database.