otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch

 Subscribe Blogs:RSS
 Subscribe Forums:RSS
 Follow New Posts:Twitter
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTM Wiki

OTM SIG
OTM Wiki
MavenWire


Data Loading Loading data into OTM / G-Log through CSVs, XML, and the UI.

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old July 1st, 2008, 18:35
Junior Member
  
Join Date: Nov 2007
Posts: 8
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 1
Thanked 0 Times in 0 Posts
Rep Power: 0
mnlv00 is on a distinguished road
Dataload to shipment table
Hi,
Pl help. We are loading data thru OTM UI to shipment table. We are testing with loading (inserts only) of 100 records. It takes 4 min to load. I dropped all b-tree indexes on shipment table, saved about 30 secs or so. Not sure what is going on...We have not customized this table or added any new indexes.
Could someone help us out ?
TIA
mnlv.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old July 1st, 2008, 18:58
Senior Member and Blogger
  
Join Date: Nov 2007
Location: Drexel Hill, PA
Posts: 378
Groans: 0
Groaned at 0 Times in 0 Posts
Thanks: 0
Thanked 67 Times in 63 Posts
Rep Power: 3
nick.polites will become famous soon enough
Re: Dataload to shipment table
What kind of server specs are you running for all of your tiers?
__________________
MavenWire Hosting Admin
www.mavenwire.com
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Location Time Zones - Incorrect time zones on location | Loading Service Times »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
OTM table sizing rj5316 Database Administration 6 December 1st, 2009 12:31
Table LANE_CALENDAR medhas Planning 0 April 29th, 2009 11:29
Custom Table njoyotm Execution 0 May 24th, 2008 07:04
Event table new_otm Database Administration 2 April 1st, 2008 15:15
Shipment Event Table shahidali12 Planning 2 June 7th, 2007 21:29



All times are GMT. The time now is 12:32.
Copyright © 2006-2009, Open Book Solutions LLC. All rights reserved.


Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40