|
PureBytes Links
Trading Reference Links
|
Mike (or Laura),
If you have a decent amount of memory on your system, it will probably be in
memory anyway. I doubt if you'll seem much difference.
If you decide to go with SQL Server, make sure that you:
- Have an index on the PK
- Put a clustered index on the on the PK or a column on which you do range
lookups, and/or
- Add necessary covering indexes.
Regards,
Dan.
_____
From: amibroker@xxxxxxxxxxxxxxx [mailto:amibroker@xxxxxxxxxxxxxxx] On Behalf
Of mikelaurataylor
Sent: Friday, August 11, 2006 6:21 PM
To: amibroker@xxxxxxxxxxxxxxx
Subject: [amibroker] Re: SQL databases
If you have a large amount of data you probably want to go SQL since
it is probably fastest. I have access already on my machine and
found linking to an access database with fairly easy and it fast
enough for my database of 10000 or so records. CSV and excel are
going to be slower because they are not databases and not optimized
for this kind of work.
--- In amibroker@xxxxxxxxx <mailto:amibroker%40yahoogroups.com> ps.com,
"brian.z123" <brian.z123@xxx> wrote:
>
> SQL database is the best ODBC Universal plugin option?
>
> I have plans for the 'external' database feature.
> So far I have tried accessing CSV and Excel tables from AB.
> CSV was sluggish and I couldn't get Xcel to work, although I didn't
> try too hard on the Xcel.
> Tomasz/support recommended SQL as the better option.
> I haven't tried SQL yet but it looks easy enough.
>
> Would anyone like to comment on the pluses/minuses of SQL versus the
> rest?
> Would SQL have a speed advantage?
>
> I appreciate that it is not quite as universal as MSFT programs
> although AB provided a free SQL link.
>
> http://www.mysql. <http://www.mysql.com/> com/
>
> Thanks to everyone who is posting on the Access topic.
> I still intend to learn how to use Access/Xcel as well.
> My general computing skills are average so I am very happy to be able
> to sit back and follow you guys or gals on this stuff.
>
> BrianB2.
>
|