I currently have a database that has 7 tables made using database desktop. Table types I think are .DB Paradox tables .!? Has a total size of 224 MB. Largest table contains +- 300000 records. Now the problem is I am querying on it and it is a simple query eg. "TheName LIKE 'Robert'". This takes forever 1 minute taking into account that the user will want to query a couple of times per minute.
Problem Source No.1 : I am running the database on , and it will have to run on computers under 500MHz with maximum 64 MB. Not much I can do about that.
Problem Source No.2 : Might be the database or not ? I have no idea. So is there an alternative to the BDE in the same price range that delivers better performance ?
Proble Source No.3 : There are not enough tables. Can a higher relationship count make the database more efficient.
Can anybody give me advice ?