Db: Oracle C# .Net 2005

I have a serious problem about performance. There is a table with 34 columns. There is only 1 row inside it. 12 tables are related with this table.

When I use: adapter.FetchEntityCollection(myEntityCollection,relationPredicateBucket,0,null) method, It takes about 10-15 seconds to open. It is realy slow although there is just one row. Why do you think it is so slow and what can I do?

I can't guess, with that much of information. Please check the following guidelines: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=7722

Also you may try to examine the generated query and run it in SQL+ or any database client tool, to check the responce time. To get the generated query, please refer to the manual: "Using the generated code -> Troubleshooting and debugging"

Also, do you use inheritance? A prefetch path?