Jump to content


Photo

Large Data


  • Please log in to reply
5 replies to this topic

#1 wolves

wolves
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts

Posted 20 September 2006 - 05:23 PM

I need to inser about 6000 registers . . .
how can I do it in 30 seconds?
I know that I can modify php timelife but I don't want it.

there is a way to stop the process, and continue after 2. 3 seconds ?

tks


#2 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 20 September 2006 - 05:31 PM

The only way to get 6000 entrys copied to a database table really fast is if you have a dedicated database server.

have you got one?
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#3 wolves

wolves
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts

Posted 20 September 2006 - 05:38 PM

no :(

and If I execute it from prompt,  maybe will be fasteR?

but I can't connect database running by the prompt :(

#4 redarrow

redarrow
  • Members
  • PipPipPip
  • Advanced Member
  • 7,308 posts
  • Locationlondon

Posted 20 September 2006 - 05:41 PM

what about if you copy the whole database reg information from the mysql bin then put it in the database you need.

trying to help.
Wish i new all about php DAM i will have to learn
((EMAIL CODE THAT WORKS))
http://simpleforum.ath.cx/mail2.inc
((PAYPAL INTEGRATION THAT WORKS))
http://simpleforum.a...aypal1_info.inc

#5 wolves

wolves
  • Members
  • PipPipPip
  • Advanced Member
  • 65 posts

Posted 20 September 2006 - 05:43 PM

the data comes from a csv file
???

#6 Daniel0

Daniel0
  • Staff Alumni
  • Advanced Member
  • 11,956 posts

Posted 20 September 2006 - 05:46 PM

I have heard that Perl is faster for such tasks, but I am not sure and I do not know Perl.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users