Re: speed of mysql insert through C api

2001-11-16 Thread Gabor Penoff
On Thu, 15 Nov 2001, Jonothan Farr wrote: > There's no way to know that without knowing the schema of the > table you're inserting into. How you index it is going to be the >biggest factor there. just a plain file with 2 columns - one of them is a decimal field - taht's all. cu, fns -[ mailto:[

Re: speed of mysql insert through C api

2001-11-16 Thread M. A. Alves
On Thu, 15 Nov 2001, Gabor Penoff wrote: > can you tell me an estimated speed about filling 100 records with > mysql insert by using the C api? Last insert job I ran did c. 400 inserts per second. This is real ("wall") time and some computations were involved. (Dont go running fetching a ca

Re: speed of mysql insert through C api

2001-11-15 Thread Jonothan Farr
rsday, November 15, 2001 2:23 PM Subject: speed of mysql insert through C api > Hi folks, > > can you tell me an estimated speed about filling 100 records with > mysql insert by using the C api? > I know the question sounds silly - all I have now is a suspicion that > I m

speed of mysql insert through C api

2001-11-15 Thread Gabor Penoff
Hi folks, can you tell me an estimated speed about filling 100 records with mysql insert by using the C api? I know the question sounds silly - all I have now is a suspicion that I make something wrong (I mean the insert seems to be quite slow here at home). cu, fns -[ mailto:[EMAIL PROTECTE