I need speed

[Sean Mancuso]

* what cache size ?
ValentinaInit( 4 * 1024 * 1024

* how many records in table?
about 8000

* how many records are found by cursors?
between 1 to 5

first it selects only the players in the database of
the opposing team, then if they are available, then it
selects the goalkeeper or attacker depending on the
repeat loop state and then the side (left, right)
could it be the Side LIKE that slows it down?

 fx = "select * from Table WHERE club
> = "&"'"&avversario&"'"&" AND Titstatus = "&0&" AND
> Ruolo > "&d1&" AND
> Ruolo < "&d2&" AND Side LIKE "&drs[I]&" ORDER BY
> Ability Desc"



		
__________________________________
Do you Yahoo!?
Yahoo! Mail Address AutoComplete - You start. We finish.
http://promotions.yahoo.com/new_mail