Re: FileMaker components

Man Utd wrote:
Yes, I got the ODBC installed with FileMaker software.
However, I found it is horribly slow to
SELECT *
FROM table1

This table have 100 fields and 2500 records on the same machine as my delphi
app.
It may take 10 minutes open the query.

Do you really need *ALL* the data in the table? (I won't ask about the table having 100 fields in it..)

Could you be more specific with your query? This could speed it up considerably.

Eg:

SELECT
FieldIWant1, FieldIWant2, FieldIWant3
FROM
TABLE1
WHERE
SomeCondition >= SomeParameter



--
Robin.
<disclaimer> Not an expert </disclaimer>
.

Relevant Pages

  • Re: FileMaker components
    ... I got the ODBC installed with FileMaker software. ... I found it is horribly slow to ... FROM table1 ... It may take 10 minutes open the query. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Displaying row no/Record Counting
    ... EnteredOn Date/Time when the record was added. ... You create a query that contains Table1. ... On each row of your query, you need to count the number of records in Table1 ... In> order to generate an alphabetical listing of these people,> I have to analyze the report in Excel and sort the> spreadsheet based on the client's name. ...
    (microsoft.public.access.queries)
  • Re: How to add to a new field based on information in existing field?
    ... a query to join the two tables. ... For example, Table1 includes fields TestID ... Table2 includes fields Description and DescriptionFr. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Non-updateable query issue
    ... You have an unnormalized table (of course, as it came from a flat spreadsheet instead of a relational source), and is it has 100 columns. ... joined to the master, showing all the records, the query is not updateable. ... > Say Fred deletes record 79 from Table1, and then Betty changes the> phone ... > Allen Browne - Microsoft MVP. ...
    (microsoft.public.access.queries)
  • Re: Non-updateable query issue
    ... Microsoft Access MVP ... When putting together that query, ... "Duane Hookom" wrote: ... Say Fred deletes record 79 from Table1, ...
    (microsoft.public.access.queries)