otmfaqForumsBlogsRegister
FAQMembers ListCalendarToday's PostsSearch

 Subscribe Blogs:RSS
 Subscribe Forums:RSS
OTMFAQ Home
OTMFAQ Blogs
OTMFAQ Forums
OTMFAQ Tutorials

OTM SIG
MavenWire


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

Tags: , ,

Reply
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old July 1st, 2008, 18:35
Junior Member
  
Join Date: Nov 2007
Posts: 8
Thanks: 1
Thanked 0 Times in 0 Posts
Groans: 0
Groaned at 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: 215
Thanks: 0
Thanked 31 Times in 31 Posts
Groans: 0
Groaned at 0 Times in 0 Posts
Rep Power: 1
nick.polites is on a distinguished road
Re: Dataload to shipment table
What kind of server specs are you running for all of your tiers?
__________________
MavenWire Hosting Admin
The Oracle OTM / G-Log GC3 Experts
Offering Incubator and Production OTM instances
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 the data into OTM via XML »


Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
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
Splitting Mutistop shipment into direct shipment while loading a SAW shipment MURTHYKO Integration and Data Mapping 0 May 28th, 2008 14:35
Custom Table njoyotm Execution 0 May 24th, 2008 07:04
Event table new_otm Database Administration 2 April 1st, 2008 15:15
Database table for Tax allocation? sray Database Administration 0 September 6th, 2007 13:51
Shipment Event Table shahidali12 Planning 2 June 7th, 2007 21:29



All times are GMT. The time now is 02:52.
Copyright © 2008, Open Book Solutions LLC. All rights reserved.

Sponsored by MavenWire - MavenWire.com


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