Re: Row with the largest character count

Tech-Archive recommends: Speed Up your PC by fixing your registry

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]
.

Relevant Pages

  • Re: Row with the largest character count
    ... I want to chop the field lengths to make the database run faster, ... The size of the field only trivially affects the speed of the database. ... Indexing the field will make searching it VASTLY faster, ...
    (microsoft.public.access.queries)
  • Row with the largest character count
    ... 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, ...
    (microsoft.public.access.queries)
  • Re: what is better - one field or eight - mysql bit testing
    ... chop. ... Some have to go through a messy change cycle to become believers. ... But understanding the data and how it will be used is critical to proper database design. ...
    (comp.lang.php)
  • Re: linked field in same directory
    ... You can get the drive for the current database with the CurrentDB.Path, ... but actually you can get the whole directory path in one go by using the ... This only returns the file name, so you can chop that off the ... You can then plug strDirectory straight into the relinking routine. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: interacting with table layouts using DBI
    ... >> and modify the layout of database tables in a MySQL DB? ... control over the creation of tables and fields, such as data types and field lengths. ...
    (perl.beginners)