In the application I am working on, it looks like I would be creating some temporary tables as part of complex sql statements. I am thinking of keeping these temp tables in a separate database file so that access to the main tables are not affected.
I would appreciate any feedback, whether this would increase performance, or if it would just create extra work for me. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com