Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Dennis76

    Slow query when joining 2 tables

    Thanks for all the answers and tips. I was very busy yesterday. Today is such a nice weather and I will take the day off to go wakeboarding. I will test everything and come back. Olaf, I already use activeVFP for serving data to our Android devices. So that would also be an option. And of...
  2. Dennis76

    Slow query when joining 2 tables

    I use VFP 9 SP2. Field Invoicenr is in both tables char and 9 long. I didn't know that it would matter. In my testdatabase I changed it to Integer and the query is inner join and left join now about 1 second. So it is a lot faster. But unfortunately I cannot change the field types in the real...
  3. Dennis76

    Slow query when joining 2 tables

    I don't have an index on DELETED(). I only have two tables with each 2 fields: table Invoices: fields: invoicenr, customernr Index: invoicenr table invoice_details: fields: invoicnr, artnr Index: invoicenr, artnr I tried to reduce the foreground/background, but still the same.
  4. Dennis76

    Slow query when joining 2 tables

    Because both tables have a large number of fields, I created 2 new tables with only the 2 neccessary fields. I then filled them with the data from the original tables. It is a bit faster, but not more than 10%. SYS(3054,11,"cmemvar"): Using index tag Artnr to rushmore optimize table d Rushmore...
  5. Dennis76

    Slow query when joining 2 tables

    Thanks for the answers. @OlafDoschke: You are right that a left join is not what I want, but an inner join was about 1 second slower. The query is executed directly in foxpro and the time is what foxpro presents to me: "xxxx records selected in x.xx seconds". Here is the output you asked for...
  6. Dennis76

    Slow query when joining 2 tables

    Hello, I have 2 tables: invoices (1M records) and invoice_details (5M records) I want to select all invoices which containe artiklenr "1234": SELECT customernr from invoice_details d left join invoices i on i.invoicenr = d.invoicenr where artnr = 1234 This query takes about 3 seconds on a...

Part and Inventory Search

Back
Top