|
From: SourceForge.net <no...@so...> - 2004-06-11 15:22:10
|
Bugs item #971192, was opened at 2004-06-11 15:02 Message generated for change (Comment added) made by ariannad You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=109028&aid=971192&group_id=9028 Category: None Group: Feature v1.5 Status: Deleted Resolution: Invalid Priority: 5 Submitted By: Arianna (ariannad) Assigned to: Nobody/Anonymous (nobody) Summary: Firebird database very slow Initial Comment: Hi, we use Firebird v 1.5 (Official) on Win32 and Linux (Debian, Mandrake 10). we have slow query after first delete I want to explain what I did. DB dimension: 1,6GB 1.Delete a lot of records from Table. 2.After delete, Run any Query 3.Server work indefinitly on disk without give any result Where is the problem? Thanks. Arianna ---------------------------------------------------------------------- >Comment By: Arianna (ariannad) Date: 2004-06-11 15:22 Message: Logged In: YES user_id=1061643 we have only one integer index assigned by generator. Thanks. Arianna ---------------------------------------------------------------------- Comment By: Sean Leyne (seanleyne) Date: 2004-06-11 15:16 Message: Logged In: YES user_id=71163 This bug tracker is not for support related issues. Please direct your posting to the Support list. ---------------------------------------------------------------------- Comment By: Nickolay Samofatov (skidder) Date: 2004-06-11 15:16 Message: Logged In: YES user_id=495356 You probably have many duplicates in indices. Firebird 2.0 doesn't have this limitation, but for verion 1.5 and earlier you should avoid having large "max dup" counter in any indices ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=109028&aid=971192&group_id=9028 |