Dear Friends,
I have a database with approximately 10 tables with about 1 lakh records
each in 3 tables, I need to know that on what factors does the speed of
mysql depends,
1)Does a table having records effects the speed of data fetch of another
table in the same database.
2)Whats the
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
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
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
On Sat, Nov 03, 2001 at 12:07:03AM +, Manjeet Singh wrote:
> Hi Group,
>
> I am new to mysql, and would like you all to give some time in
> resolving my trouble. I am stuck up with a problem of designing
> stores database for a big company.The company is located in
> different places and want
Hi Group,
I am new to mysql, and would like you all to give some time
in resolving my trouble. I am stuck up with a problem of
designing stores database for a big company.The company is
located in different places and wants web-based insertion,
retrival and maintaining of data and records in the
Hi.
Do you have an index SIC? If so, I don't know any reason which would
explain such a slow server for such a simple query (on a table with
only 9.000 records), no matter what the configuration is.
If SIC is one of those unidexed decimals, the speed may be expected,
depending on the database si
On Fri, Jun 15, 2001 at 05:51:11PM -0600, Chris Cameron wrote:
>
> I compiled MySQL 3.23.37 myself with -O6's -march-i586 and various
> ./configure options I don't remeber. The database I'm using has 3
> tables of about 9 thousand entries, un-indexed decimal(5,8)'s, and a
> few tinytext's. There
I'm currently using a 166 UNIX machine for a dedicated MySQL database,
and I'm interested in knowing what kind of speed I should be expecting
from it. I ask because right now it's at a point of being unusable even
for development on some of the larger queries.
I compiled MySQL 3.23.37 myself with
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 question.
I use FreeBSD4.2-RELEASE + mysql-3.23.32
Dual
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 m
hi,all
i have a strange question.
I use FreeBSD4.2-RELEASE + mysql-3.23.32
Dual PIII667+ 768MB RAM
I have a table like this
CREATE TABLE ABC (
A int(10) unsigned DEFAULT '0' NOT NULL,
B int(10) unsigned DEFAULT '0' NOT NULL,
C0 bigint(20) unsigned DEFAULT '0' NOT NULL,
C1 bigint(20) u
13 matches
Mail list logo
