Speed of Finds?

Classic Servoy
1

OK, still playing with my test database.

I have indexed key fields on a 300,000 record payment database.

I’m finding that it takes about as long to find a 90,000 record set, as it does to find a 257 record data set, as it does a 1 record dataset. Both are taking significantly longer to find then in my Filemaker database, probably a good 30 seconds or so per find.

I’m running against an Oracle database.

Am I doing something wrong?

Thanks,
Lee Snover

2

leesnover:
OK, still playing with my test database.

I have indexed key fields on a 300,000 record payment database.

I’m finding that it takes about as long to find a 90,000 record set, as it does to find a 257 record data set, as it does a 1 record dataset. Both are taking significantly longer to find then in my Filemaker database, probably a good 30 seconds or so per find.

I’m running against an Oracle database.

Am I doing something wrong?

Thanks,
Lee Snover

Just an update. A single record find on a unique index is more or less instant. The other finds seem to be unusually slow, but I’m not quite sure what Servoy is doing behind the scenes.

Regards,
Lee

3

Run Servoy with stacktrace turned on and you can see the queries it executes on the database.

Paul