Re: slow sql server DB reads

2005-05-24 Thread Larry Bates
If GUID is not a key in the database make it one. That way you won't have to do serial reads through the entire table to locate matching entries. It is hard to be more specific because we don't know how many records are in ASPSessionState table. If there are only a few, the problem is probably e

slow sql server DB reads

2005-05-23 Thread bart
I run a python website on a IIS server. I replaced my flat file DB with SQL server, but the reads are very slow. 7 seconds for 3 querrys like these conn= adodbapi.connect( "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=xxx;Initial Catalog=dlpl;Data Source=(local)" ) c