Hello everyone,
I have a little problem with a Table im using to store notes on articles:
Design:
id - int - identity (auto)
Title - varchar(50)

currently the table is containing ~12000 datasets (not much if you ask me).

Problem:
If I try to edit/add recordsets, I get a timeout.
In Access:
'ODBC Error adding recordset'

In SQL
- None - Timeout (I Quit after 2.5 minutes of INSERT query)

does anybody know a solution to this problem?

Thanks for helpin'!

In Addition to the upper text:

Strangely it works sometimes - I know that this should be that slow, the textfield is indexed - w/o duplicates - but i have used the same structure for other tables (with over 5 times as much data) and there it works..

Is it possible that indexing w/o duplicates causes this problems?

Have you tried inserting via Enterprise Mgr to see if you get the same error?

Have you seen what's happening through, for instance, SQL Profiler?

I've tried trough Access, Acced direct table edit, SQL Query Analyzer - all have the same problem (except that QA doesn't have a set timeout)...

Which type of index are you using ? In your previous instances where you had no problems, did you have the index using the "without duplicates" option ?

In the troubled table i'm using index: w/o duplicates - in the not troubled table the row is indexed but with duplicates...
another problem is - I currently cannot change this, because I dont have enough space for the transaction log to save 15000-50000 rows (indexes)