Re: [PHP] Re: Issue with the huge import script

2009-08-16 Thread Ashley Sheridan
On Sun, 2009-08-16 at 04:06 +0200, Ralph Deffke wrote: Hi, this sounds huge, and cries for a sql version of the import. Are both databases the same? MySQL? I give u a draft for MySQL u export the data u have, then u got a textfile with 10+ sql statments in the php script u open the

Re: [PHP] Re: Issue with the huge import script

2009-08-16 Thread Ralph Deffke
because I assume always that a requester got some intelligence, so in that case there must be a reasonsble reason why he wants to do it in PHP im not like u assuming everybody is a thumb ralph Ashley Sheridan a...@ashleysheridan.co.uk wrote in message news:1250413427.2344.51.ca...@localhost...

Re: [PHP] Re: Issue with the huge import script

2009-08-16 Thread Ashley Sheridan
On Sun, 2009-08-16 at 11:05 +0200, Ralph Deffke wrote: because I assume always that a requester got some intelligence, so in that case there must be a reasonsble reason why he wants to do it in PHP im not like u assuming everybody is a thumb ralph Ashley Sheridan

Re: [PHP] Re: Issue with the huge import script

2009-08-16 Thread Ralph Deffke
so then tell me tell me what my first sentence means this sounds huge, and cries for a sql version of the import. it looks like u have no experience in working as consultant hotlines Ash first the folk is asking for a sulotion of HIS php implying a general solution in PHP with a hint to the

Re: [PHP] Re: Issue with the huge import script

2009-08-16 Thread Ashley Sheridan
On Sun, 2009-08-16 at 11:25 +0200, Ralph Deffke wrote: so then tell me tell me what my first sentence means this sounds huge, and cries for a sql version of the import. it looks like u have no experience in working as consultant hotlines Ash first the folk is asking for a sulotion of HIS

[PHP] Re: Issue with the huge import script

2009-08-16 Thread Ollisso
On Sun, 16 Aug 2009 04:15:12 +0300, Devendra Jadhav devendra...@gmail.com wrote: Is it because of the size of the records or something else...? Please suggest me some solution which is faster, safe and easy to code :D What about using insert ignore ? :) 1. add UNIQUE constraint on a key

Re: [PHP] Re: Issue with the huge import script

2009-08-16 Thread Ralph Deffke
better consider if u r insulting I've seen a view posts of u falling into that category i w'ld recomment respect posters first approaches even if they r stupid and incorporate the respect in the way u answer the comment you r crying ... is an insult. Ashley Sheridan a...@ashleysheridan.co.uk

[PHP] Re: Issue with the huge import script

2009-08-15 Thread Ralph Deffke
Hi, this sounds huge, and cries for a sql version of the import. Are both databases the same? MySQL? I give u a draft for MySQL u export the data u have, then u got a textfile with 10+ sql statments in the php script u open the file and iterate over it by line (carefull it could be also ;