Den 2012-02-13 21:46 skrev nathanelrick s�h�r:

>
>
> > First, stop worrying about the disk space being wasted. That's a
> problem
> > for Access and similar. "Real" database managers don't suffer from that
> > kind of problem. Period
> >
> > Based on my experience, it is usually a lot faster to drop a table and
> > recreate it, than to delete all the records. I'd recommend you use that
> > approach to clean it out each night.
>
> unfortunatly i can not do so because drop the database need an
> exclusive access to it :(
>

Not drop database, just the table. But perhaps your app has the same
problem with this: insufficient rights...?

Kjell

--
--------------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64



[Non-text portions of this message have been removed]