> Well. I need to create a window that maintains the postal codes and I need
> Cod Descr, and Country fields for that. The Window simple have a few
> buttons(First, Previous, Next, Last, New, Delete...etc.) That needs The
> complete big recordset or the simple little recordset with a limit clause.
>
>
> -Mensaje original-
> De: Don Read [mailto:[EMAIL PROTECTED]]
> Enviado el: viernes, 13 de julio de 2001 18:14
> Para: David Tomas Fargas
> CC: [EMAIL PROTECTED]
> Asunto: RE: Dificult question.
>
>
>
> On 13-Jul-01 David Tom`s Fargas wrote:
>
>
On 13-Jul-01 David Tomas Fargas wrote:
> Well, sorry about my worst explanation :)
>
> The table is a Spain Postal Codes Table.
> It has fields: Cod(5),Descr(100),Country(3),IND(13),ORD(3).
> All are varchars.
> Because there are possible to have the same Postal Codes and diferent
> description
nviado el: viernes, 13 de julio de 2001 18:14
Para: David Tomas Fargas
CC: [EMAIL PROTECTED]
Asunto: RE: Dificult question.
On 13-Jul-01 David Tom`s Fargas wrote:
> I Have a large table with 59.000 records and if i execute a simple select
> since "Select * from table order by cod&quo
ra: 'David Tomàs Fargas'
Asunto: RE: Dificult question.
Have you created indexes on that table?
Regards,
Gary Huntress
Code 4113
Naval Undersea Warfare Center
Newport, RI 02841
1-800-669-6892 x28990
-Original Message-
From: David Tomàs Fargas [mailto:[EMAIL PROTECTED]]
S
On 13-Jul-01 David Tomàs Fargas wrote:
> I Have a large table with 59.000 records and if i execute a simple select
> since "Select * from table order by cod" it takes 4 seconds to process
> query!
> and if table will have 590.000 then... well, you see it.
>
> It's possible to accelerate it, with
I Have a large table with 59.000 records and if i execute a simple select
since "Select * from table order by cod" it takes 4 seconds to process
query!
and if table will have 590.000 then... well, you see it.
It's possible to accelerate it, without where and limit clausules?
I think no, and in m
I Have a large table with 59.000 records and if i execute a simple select
since "Select * from table order by cod" it takes 4 seconds to process
query!
and if table will have 590.000 then... well, you see it.
It's possible to accelerate it, without where and limit clausules?
I think no, and in m