hat if several customers tries to buy the
same stocks at the same time ?? Any locking methods?
Any hints & tips to best design such an database and/or application I'll appreciate it.
I'm open for any suggestions.
If it does matter: I'm going to use MySQL & Delphi Enterprise 6
Kind Regards
Thomas Kvamme
Devin Miller wrote:
>
> I am pretty new to mysql and have been teaching myself slowly how to use
it.
> I am however stuck on a problem. I login to mysql as user root and created
a
> database named devin. I then issue the following commands:
>
> GRANT ALL PRIVILEGES
> ON devin.*
> TO dmiller@"%"
> I
which required the
select command to do a full scan I got a greate speed by just moving the
Cover field to a separate table... and by adding the ID to the Index I
gained another fraction of second :-)
Again.. Thanks to you all for the support
Kind Regards
Thomas Kvamme
[EMAIL PROTECTED]
--
Sql\Data\ directory... and of
course unable to tell which table it belong to reading the name of it.
Another question: When I use "SELECT COUNT(ID) FROM DVD" I always get 320
records as the result.
But in MySQL CC when I Right-Click on the Table and Select &
er is at the beginning of the next record and
ready to read it.
In Paradox all Non-Fixed-Length fields such as Blob fields etc. are stored
in a separate file... while the primary file only contains pointers to the
Dynamic file if you like
So taking a full scan doesn't require it t
Zak Greant wrote:
> I am coming in a bit late on this - however, did you send in a copy of
> the table structure?
>
> It sounds like you don't have indexes on the tables.
>
> --zak
>
> On Sun, Jan 26, 2003 at 12:59:31AM +0100, Thomas Kvamme wrote:
> > Hi again,
ROUP BY on the same table in MySQL takes 13 seconds... still can't belive
it.
--
Thomas
- Original Message -
From: "Bhavin Vyas" <[EMAIL PROTECTED]>
To: "Thomas Kvamme" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, January 25, 2003
Hi Bhavin.
Thanks for taking interest in my problem...
Here is the table definition as requested.
I'm sorry I could take a full dump... Each record consist of approx 600 KB
(just as in the Paradox table) so the file would be very big. (200 MB).
Kind Regards
Thomas Kvamme
[EMAIL PROT
is installed on the same Harddrive so
harddisk speed shouldn't be a factor.
Appreciate any help to solve the above :-)))
Kind Regards
Thomas Kvamme
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com