in reply to Re: Problem with database under Win32
in thread Problem with database under Win32
Using SELECT TOP 1 From ..... ORDER BY ID DESC may be faster than trying a "Max".
I am not a SQL weenie though - you may want to check with your DBA as to why the subquery seems "slower".
In Section
Seekers of Perl Wisdom