Just for testing the speed of Servoy finding data I made a
simple solution with 3 fields and 200.000 rows.
A search takes about 4 seconds.
Is it possible to speed up the search by putting an index on a field and how do I do this?
For now you have to use a other tool for that.
We will give you an option that you can make an index in servoy. (not in 2.0 but later on.)
Are there some general guidelines to follow for us FMP folks in terms of when we should or should not index a field, assuming we’re using a Firebird database? I downloaded the 10 meg Firebird manual and don’t know where to look.
Thanks
Servoy works mainly on the primary key, which is indexed automaticaly in each SQL database.
Only when a user search is performed it searches on other columns, so if you know a column is vastly used in user searched and is performing badly you could create an index on that column
Jan Blok:
Servoy works mainly on the primary key, which is indexed automaticaly in each SQL database.
Only when a user search is performed it searches on other columns, so if you know a column is vastly used in user searched and is performing badly you could create an index on that column
I believe Sybase SQLAnywhere V9 will automatically index columns which are frequently searched.
Tony_Adrian:
I believe Sybase SQLAnywhere V9 will automatically index columns which are frequently searched.
yes so does mssql
how about mysql 4.1.x?
I don’t know if mysql auto indexes columns you should look at the mysql docs.
But much better is to do it youreself. Just analyse where you search on most often and which column has the most different values in it (so a boolean/bit field that only has a 1 or a 0 don’t have to be indexed, except maybe if you have many 0 and you only want to have the few 1’s)