Re: when do you outgrow access?

I'm GUESSING that the date format in Paradox is different
from that in Access, and Access is bringing the data into
Access to do the date conversion, rather than asking Paradox
to select the records. If so, you may be able to get an
immediate speed up by querying using a native Paradox format
rather than a Jet/VBA date. For example, in Access (using
mdb tables), this is faster:
select * from tbl where dat > 10305
than this:
select * from tbl where dat > #03/18/1928#
because the numeric format is closer to the native format.

(david)


"HarvestWind" <harvestwind@xxxxxxxxxxx> wrote in message
news:toudnTPD4cWdewXfRVn-iw@xxxxxxxxxxxxxx
> Ken...
> Noted your statement "millions upon millions of records"...
>
> I am using Access 2000 and linked to a Paradox table with just over
> 500,000
> records. I use Access to process the table to get all records that have
> been added with a certain date...the date filed is indexed in Paradox (and
> in Access when linked)...It is not a compliated query...but it takes
> almost
> three hours to run...with a 2.8 gig processor... Maybe I'm doing
> something
> wrong with the search...but I can't imagine trying to do the same with
> "millions upon millions of records"... I'd have to start it on Friday
> before
> leaving work and hope to have my data by the next Thursday!
>
> JP
>
>
> "Ken Snell [MVP]" <kthsneisllis9@xxxxxxxxxxxxxxxxxx> wrote in message
> news:euviAgyYFHA.612@xxxxxxxxxxxxxxxxxxxxxxx
>> When you need
>> -- completely "lockdown" security on the data;
>> -- 50 or so users concurrently;
>> -- millions upon millions of records;
>> -- money is available to pay for much more expensive software and
>> developers
>> -- web access that is fully secure;
>>
>> and a few other things potentially. Tell your IT department that it
>> should
>> enjoy its great benefits for low costs.
>>
>>
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>> "Donna" <Donna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:D2A064D0-B609-4F1E-9316-2FCF43B2AAD6@xxxxxxxxxxxxxxxx
>> > Just wondering....IT department bags on access and pushes to change.
>> >
>> > thanks,
>> > Donna
>>
>>
>
>


.

Relevant Pages

  • Re: Changing dates
    ... Malcolm wrote: ... >below but I have recently upgraded from Paradox 8 to Paradox 9 and from ... The date field in Excel is formatted as dd/mm/yyyy, ... >same as my preferred Paradox format. ...
    (comp.databases.paradox)
  • Re: when do you outgrow access?
    ... using an access based system to take online applications for students who ... > Access to do the date conversion, rather than asking Paradox ... > immediate speed up by querying using a native Paradox format ...
    (microsoft.public.access.gettingstarted)
  • Re: Query fails to retrieve data
    ... I am not sure if it is Paradox application or ... table format only. ... I got it with Borland Delphi and has Database Desktop ...
    (comp.databases.paradox)
  • Changing dates
    ... I don't know whether there is a connection with my problem expressed below but I have recently upgraded from Paradox 8 to Paradox 9 and from ... The date field in Excel is formatted as dd/mm/yyyy, the same as my preferred Paradox format. ... However, on importing this file, the format appeared in Paradox as mm/dd/yy and the field was alphanumeric. ... I changed the field to Date and the format changed OK to dd/mm/yyyy, BUT all dates which in the spreadsheet ended in '2004' were, in the Paradox table created by my import, shown as '04'. ...
    (comp.databases.paradox)
  • Re: when do you outgrow access?
    ... Sounds like your query may need some fine-tuning. ... <MS ACCESS MVP> ... > been added with a certain date...the date filed is indexed in Paradox (and ... >>> Just wondering....IT department bags on access and pushes to change. ...
    (microsoft.public.access.gettingstarted)