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:[
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
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.
--jfarr
- Original Message -
From: "Gabor Penoff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 15, 2001 2:23 PM
S
oh.
no.i am not talking about of the speed of SELECT.
my problem is the speed of INSERT and UPDATE.
evenmore indexes only slow down the speend of insert,update.
i ruduce the index to only i need.
-
What sort of queries are you doing on this large table? I notice you only have
What sort of queries are you doing on this large table? I notice you only have
a couple of the fields indexed
jason
- Original Message -
From: "chchen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, February 10, 2001 6:35 PM
Subject: Speed of mysql
hi,all
i have a strange
