|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
February 20th, 2007, 06:35 AM
|
|||
|
|||
|
Indexing Problem...
Okai,
Like Transactions, Indexing is too acting like necessary evil for me. I just created a table and indexed (ascending by default) its one of its column. Then i inserted data in the table, and it took some time, Time which was much less than time taken to insert when i tested with indexing three of its column (to ascending and one descending). I think this is normal.. But, it is taking me very much of time. I indexed the columns to make search query fast. But due to this insertion process slow. Note: I have to insert millions of records and it keeps on incresing. I also tried doing like: ALTER INDEX ind_name INACTIVE; Insert data in table ALTER INDEX ind_name ACTIVE; Then i updated index statistics. For small lump of data in table this works fine. But when data is huge then.. i guess "ALTER INDEX ind_name ACTIVE" tries to re create index. So i noticed FB creating temp files (under my profiles \Local Settings\temp) and as i dont have enough primary space so it just threw exception.. and that was the end of my hopes.  I dont know where i went wrong.. Please point me the right way to do this things.. I want to make both insertion and search fast. and also support TB of data. Pre-Thanks for any suggestions
|
|
#2
February 20th, 2007, 09:03 AM
|
||||
|
||||
|
Try dropping and recreating indexes, disabling and reenabling is the common way, but ...
Note that anyone claiming Quote:
Quote:
Indexing slowing down inserts is a common problem in datawarehouses, solved as I said before.
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias)
|
|
#3
February 21st, 2007, 05:17 AM
|
|||
|
|||
|
Quote:
Cant we just give FB another path for doing those stuffs.. i mean other than primary drive and also why is it taking such a huge space i my temp folder just to reindex. Building up infrastructure isnt something some one should suggest me. I am out here asking for some help.. Thanks, for all the support
|
|
#4
February 21st, 2007, 06:27 AM
|
||||
|
||||
|
Quote:
Quote:
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > Indexing Problem... |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
