Jump to content

NEED HELP.....ODBC


This topic is 8307 days old. Please don't post here. Open a new topic instead.

Recommended Posts

i have already install filemaker pro 5.5 and i do connection to

filemaker via ODBC . i use ASP. the problem is too slow when i want list

data filemaker. the size's file is 11,317 KB and 11,264 Records.

it's very slow over 25 minutes

i do select like this :

SELECT Allette1.name, Allette1.COMPANY FROM Allette1 where

upper(left(allette1.company," & len_letter & ")) ='" & letter & "' order

by company,name"

what should i do to make fast ?

thanks

Link to comment
Share on other sites

This topic is 8307 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.