I am running this in the same machine as the database though. Thanks On Tue, 2006-12-05 at 16:02 -0500, Jan de Visser wrote: > On Tuesday 05 December 2006 3:56 pm, Wei Weng wrote: > > I have a table that has roughly 200,000 entries and many columns. > > > > The query is very simple: > > > > SELECT Field1, Field2, Field3... FieldN FROM TargetTable; > > > > TargetTable has an index that is Field1. > > > > The thing is on this machine with 1Gig Ram, the above query still takes > > about 20 seconds to finish. And I need it to run faster, ideally around > > 5 seconds. > > I suspect it's the time needed to ship the data over the wire. Don't forget > you're asking for an awful lot of data... > > > > > Wei > > > > jan >
