Even more fun info here, is that if your JDBC driver (like say the DataDirect driver) uses NVARCHAR parameters with maximum widths (4000), SQL Server 7.0 will take forever to give you results. In our case, from 1 second using a VARCHAR (or even a shorter NVARCHAR) to 18 seconds. This problem doesn't appear in SQL Server 2000.
Now, the part about not using an index I have no idea about. Would be interesting to investigate. Thanks, Patrick __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com ------------------------------------------------------- This SF.net email is sponsored by: VM Ware With VMware you can run multiple operating systems on a single machine. WITHOUT REBOOTING! Mix Linux / Windows / Novell virtual machines at the same time. Free trial click here:http://www.vmware.com/wl/offer/358/0 _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
