 |
 |
Find a programming school near you
php-db | 2000121
Date: 12/09/00
- Next message: Doug Semig: "RE: [PHP-DB] Which unique field to track during a PHP4 Session?"
- Previous message: Jason Dwyer: "RE: [PHP-DB] Which unique field to track during a PHP4 Session?"
- In reply to: Adv. Systems Design: "Re: [PHP-DB] VARCHAR/CHAR question..."
- Next in thread: Anthony Martin: "RE: [PHP-DB] VARCHAR/CHAR question..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Od: "Adv. Systems Design" <asd_2000 <email protected>>
Temat: Re: [PHP-DB] VARCHAR/CHAR question...
> ...it really makes little difference...in terms of
> storage, if you really plan to have so many records
> that this would be of consequence, you are probably
> better off going with a databa$e like oracle...
I know this issue from InterBase.
In case of real databases, the engine has something called "query optimizer"
which takes your query and looks if it can be executed faster, specially if
you use joins, orderings or groupings. The case of CHAR(n) vs VARCHAR(n) is
also considered by optimizer - it tries to determine real field length for
VARCHAR(n), while CHAR(n) has already its real length defined. This does not
mean, that you will see variable field lengths in a result set, but the
optimizer must know it to succesfully allocate enough memory for descriptor
area.
Cheers
Jarek Zgoda
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe <email protected> For additional commands, e-mail: php-db-help <email protected> To contact the list administrators, e-mail: php-list-admin <email protected>
- Next message: Doug Semig: "RE: [PHP-DB] Which unique field to track during a PHP4 Session?"
- Previous message: Jason Dwyer: "RE: [PHP-DB] Which unique field to track during a PHP4 Session?"
- In reply to: Adv. Systems Design: "Re: [PHP-DB] VARCHAR/CHAR question..."
- Next in thread: Anthony Martin: "RE: [PHP-DB] VARCHAR/CHAR question..."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
