Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
More more more performance problems.
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 ?