| Subject | Is it natual ? |
|---|---|
| Author | xuxu |
| Post date | 2005-03-31T09:04:22Z |
firebird-support！
There are about 6-8 connections with my FB db. The operations will become slowly when they operate the db at the same time .Spended time of a operation will be 30-3000 seconds .The operations normally like these:
1. select count(cdrid) from callingcdr where ...;
2. select sum(dialfee) from callingcdr where ...;
( 1,000,000 records in the table callingcdr, about 100,000 records will be affected, Indexed )
3. select feerate from feetbl where areacode like '0'||'%' ;
( 1000 records in the table feetbl, Indexed )
Does it seem natual ?
There are about 6-8 connections with my FB db. The operations will become slowly when they operate the db at the same time .Spended time of a operation will be 30-3000 seconds .The operations normally like these:
1. select count(cdrid) from callingcdr where ...;
2. select sum(dialfee) from callingcdr where ...;
( 1,000,000 records in the table callingcdr, about 100,000 records will be affected, Indexed )
3. select feerate from feetbl where areacode like '0'||'%' ;
( 1000 records in the table feetbl, Indexed )
Does it seem natual ?