Re: Row with the largest character count
- From: efandango <efandango@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 17 Aug 2008 10:07:00 -0700
Very perceptive of the two John's... I didn't realise that field length has
so little impact on overall speed. (though I could have sworn i've read stuff
on here that say's that it does)
any thanks guys (you too Karl), at least i won't have to waste my time
retro-cutting umpteen tables.
"John W. Vinson" wrote:
On Mon, 11 Aug 2008 07:11:04 -0700, efandango.
<efandango@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Is there a way of finding out which field row has the largest character count?.
I want to chop the field lengths to make the database run faster, but don't
want to chop any real data off.
the table is tbl_Street_Names
the field is: StreetName
Don't bother.
The size of the field only trivially affects the speed of the database.
Indexing the field will make searching it VASTLY faster, regardless of its
size; and as soon as you truncate the field to 20 characters, you'll get a new
address on Hanuakupalukamakalahana Boulevard. (No, I don't think it's real...)
I believe the US Postal Service has a standard limit on name lengths, you
might just want to go with it.
--
John W. Vinson [MVP]
- References:
- Row with the largest character count
- From: efandango
- Re: Row with the largest character count
- From: John W . Vinson
- Row with the largest character count
- Prev by Date: Re: incorrect Rounding MsAccess 2003
- Next by Date: Re: Find Matched Records
- Previous by thread: Re: Row with the largest character count
- Next by thread: report recordsource from crosstab which columns varies
- Index(es):
Relevant Pages
|
