I can't really speak to OLEDB optimization, but I can speak to changing
over to PHP.
The MySQL database connector in PHP is pretty good from a performance
standpoint, and PHP itself is blazing fast in my experience. I've seen
massive performance gains in PERL by creating an abstraction that
PREPAR
It's been my experience that adjacency lists like what you describe are
difficult to query. I have had success with nested sets to represent
that kind of hierarchical data.
More information at:
http://users.starpower.net/rjhalljr/Serve/MySQL/traer.html
-Original Message-
From: Joe Mello
I've had tens of thousands of items in an "IN" list without failure, but
it seems that when you get that many it takes a very long time to parse.
The speed thing bothers me, so I'm toying with a new design, but it's a
big enough system that it's slow going.
J
-Original Message-
From: Ba
Any chance that there's a quarterly strategic roadmap published
somewhere?
I have projects that sometimes depend on a feature in the next rev' or
some such, and I need to plan out for my organization... Difficult to
answer my boss when the dependencies are released "when they're ready."
-Or
LL
...returns tens of thousands of records.
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 17, 2003 8:44 AM
To: Knepley, Jim
Cc: [EMAIL PROTECTED]
Subject: RE: Null-safe equal help, please
Please reply to the list so that others can follow this discussion
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 16, 2003 5:44 PM
To: Knepley, Jim; [EMAIL PROTECTED]
Subject: Re: Null-safe equal help, please
At 15:22 -0700 12/16/03, Knepley, Jim wrote:
>>I've got a WHERE clause:
>>WHERE possi
I've got a WHERE clause:
WHERE possibly_null_value IS NULL
That works fine. This null-safe equal doesn't do what I expect:
WHERE possibly_null_value <=> NULL
The manual, and my testing, shows that NULL <=> NULL evaluates to 1, so
my now-fevered mind sees no reason the two above statements are n
Is it anyone elses experience that queries with large IN stanzas in a
WHERE clause don't scale very well?
It seems like it's beyond a linear performance hit when I have a large
number (thousands) of tokens in an IN clause, even when the matching
field is indexed.
Is this something that buffer twe
http://www.mysql.com/doc/en/MyISAM_table_formats.html
"In the future you will be able to compress/decompress tables by
specifying ROW_FORMAT=compressed | default to ALTER TABLE."
Anyone know when this future is?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To uns
The docs explicitly say that wildcards are allowed when specifying
database names in GRANT commands, but don't say anything about wildcards
being allowed in table names.
For example, in one large database I have table names that are grouped
by function:
security.ids_events
secuirty.ids_correlatio
I'm basing some work on Joe Celko's excellent idea of using nested sets
to represent an organizational structure as opposed to an adjacency
list. By and large it's a great idea, but not without its pitfalls. I'm
writing now to ask your collective opinion of the best practice.
I've got my nested se
You're describing an adjacency list model, which is the most obvious
structure but arguably not the best.
Another data structure for this kind of thing is described at:
http://groups.google.com/groups?selm=%230%23O0OiFBHA.1932%40tkmsftngp04&;
oe=UTF-8&output=gplain
Cheers,
Jim
-Original
See http://www.mysql.com/doc/en/TODO_future.html
"Oracle-like CONNECT BY PRIOR ... to search tree-like (hierarchical)
structures."
Whatever their definition of "The Near Future" is... I'd guess v5
J
- Original Message -
From: "Bernhard Schmidt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
I have had similar performance concerns, but on a much smaller scale.
The data was well indexed, but took far too long to query (particularly
with aggregate queries).
Check the individual row size of your table. In my case, I had a TEXT
field that would frequently be fairly long. Moving that fiel
ECTED]
Sent: Thursday, June 12, 2003 9:16 AM
To: Adam Nelson; Knepley, Jim; 'Rodolphe Toots'; [EMAIL PROTECTED]
Subject: Re: mySQL GUIs
Hi Jim & Mysql List members,
sad to hear that there are still people around not using a propper OS ;-) -
like a Linux, BS
I'm a big fan of Scibit's "Mascon"
-Original Message-
From: Rodolphe Toots [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 11, 2003 5:17 AM
To: [EMAIL PROTECTED]
Subject: mySQL GUIs
hi!
i am looking for a good mySQL gui for windows
i have used mySQL front, which was an excellent free
16 matches
Mail list logo
