Have a look into indexes.... I'm running selects on tables with about 4.5 million rows on a desktop without problems.
Bob Irwin wrote: > G'day, > > I'm doing a select on a database that has about 45000 records and growing > and its a bit SLOW. > > Its using a unix timestand to mark the beginning of a call and the end of > a > call. This is also used so I know what date the call was received. > > When I do a > > select * from support where begintime between 'timestamp1' and > 'timestamp2'; > > It takes a while to execute... The timestamp fieldtype is varchar(10)... > Will I see any speed difference with a different column type? > > Any advice on how to speed this up would be greatly appreciated! :) > > Best Regards > Bob Irwin > Server Admin & Web Programmer > Planet Netcom -- Cheers, Owen Prime http://www.noggin.com.au -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
