|
PureBytes Links
Trading Reference Links
|
SQL is built on top of ISAM (index sequential access
methodology). Basically this strategy is fastest on
look-ups overhead is thrown in to the insert side.
If you are inserting ungodly amounts of data quickly
then you have to architect for that... such as tick by
tick on all symbols.
Advantage to SQL is relative ease & speed of data
mining. You can also get tools that help with this.
--- mikelaurataylor <mikelaurataylor@xxxxxxxxx> wrote:
> 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@xxxxxxxxxxxxxxx, "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.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.
> >
>
>
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
|