one thing to get it a bit faster is to deactivate all indices on the table
before issuing the delete. For larger tables this will significantly speed
up the deletion. After that just reactivate the indices again.

CU, Nick

""Martijn Tonies"" <m.tonies@...> schrieb im Newsbeitrag
news:013601c1949c$4fc823d0$0a02a8c0@seal...

> Hi,
>
>
> >Happy New Year!
>
> Same to you.
>
> >Is there a way to delete ALL the records from a table REALLY fast.
> >In SQL Server there is a TRUNCATE TABLE MyTable function that is very

fast

> >How can I do that in FB RC2?
>
> There's no other way than DELETE FROM table - just the normal way.
>
>
> Martijn Tonies
> InterBase Workbench - the developer tool for InterBase and Firebird
> http://www.interbaseworkbench.com
>
> Upscene Productions
> http://www.upscene.com
>
> "This is an object-oriented system.
> If we change anything, the users object."
>
>
>
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>