Dose Perspective to an extent improve the cube process performance?

Hi, all experts here,

Thank you very much for your kind attention.

Would please any expert here give me any guidance and advice that if a Perspective of a cube really improve the performance of the process in terms of process speed.

Thank you very much in advance for any guidance and advice for that.

With best regards,

Yours sincerely,

Perspectives don't affect cube processing in one way or another. Think about Perspective vs. Cube as about View vs. Table.|||

Hi, Mosha, thank you very much for your guidance.

So is it in a way like views for tables make retriveving data faster from a perspective rather than a large cube as what views meant to tables. Dose that sense perspective mean to cube (besides in a way to well organize information in cube for specific perspective)? Thanks a lot.

With best regards,

Yours sincerely,

|||Retrieving data from perspective will have exactly same performance as retrieving data from the cube. Perspective is mostly just a way to hide some dimensions/measures/actions/calculated members to have less cluttered and more focused view on the cube. But all the queries go against the cube.|||

Hi, Mosha, thank you very much for your guidance.

With best regards,

Yours sincerely,

Dont know which database to use for the following site

Hi All,

Just wondered if i could ask you for some advice and help.

I'm looking to write a site, and one of the functions of the site is to remind the user of a certain event at a certain time. I was wondering how i would do this? or if anyone has a working example i could use?

Also I dont quite know what database to use..... would MySQL do the function i am after?? If so then no more problem lol If not what database would you recommend i use?

Thanks

Dannyi recommend mysql

which language are you planning to use? perl? coldfusion? asp?|||do the whole thing in clipper or ada as the front end code.|||Well im looking to do it in perl. But thats not really my skill, but its a good enough time as any to start learning it. I know more asp than anything.

The only issue i have is, the site is hosted on a NAMESCO server that has MYSQL. And as i have never used MYSQL i dont know how to configure it...... not only that, i could probably know how to set it all up if i had some sort of interface to it. But theres nothing.

Probably me having a noob moment, but anyone know what i mean?

Thanks

Dan|||well, you can use asp with mysql as well

your interface to mysql could be one of the mysql utilities available on the mysql site

or you could use Heidi SQL, which is what i use, it's really great

domain user or local system account ?

Hello,
My server is part of a W2K domain. What do you advice me as account to
run my SQL*Server, service started with a domain user account or as
local system ?

I need advices from a security point of view.

Thank's in advanceDepends on your requirements...

First, I would personally never recommend running SQL in a production
environment as Local System.

If the SQL proccess will ever need to connect to file shares on other
machines (like to backup data to remote location etc...) then you can either
use a domain account, or use local accounts with matching usernames and
passwords on the SQL server and any machine it may connect to.

If your SQL proccess will never connect to File shares, or similar resources
on the network, then you should run it with a Local User account on the box.

But of course, this is just my opinion.

GL

"Kona" <kona_iron@.yahoo.fr> wrote in message
news:a1de658a.0404191607.75ec6a49@.posting.google.c om...
> Hello,
> My server is part of a W2K domain. What do you advice me as account to
> run my SQL*Server, service started with a domain user account or as
> local system ?
> I need advices from a security point of view.
> Thank's in advance|||Thank you for your opinion.

And I also agree to not use Local System, all the more since this
account as network access into the same W2K domain (that was not the
case under NT).

"GL" <GL@.noSpam.ReplyToNewsgroup.com> wrote in message news:<108ddd45gbs8k69@.news.supernews.com>...
> Depends on your requirements...
> First, I would personally never recommend running SQL in a production
> environment as Local System.
> If the SQL proccess will ever need to connect to file shares on other
> machines (like to backup data to remote location etc...) then you can either
> use a domain account, or use local accounts with matching usernames and
> passwords on the SQL server and any machine it may connect to.
> If your SQL proccess will never connect to File shares, or similar resources
> on the network, then you should run it with a Local User account on the box.
> But of course, this is just my opinion.
> GL
> "Kona" <kona_iron@.yahoo.fr> wrote in message
> news:a1de658a.0404191607.75ec6a49@.posting.google.c om...
> > Hello,
> > My server is part of a W2K domain. What do you advice me as account to
> > run my SQL*Server, service started with a domain user account or as
> > local system ?
> > I need advices from a security point of view.
> > Thank's in advance|||Depends on your requirements...

First, I would personally never recommend running SQL in a production
environment as Local System.

If the SQL proccess will ever need to connect to file shares on other
machines (like to backup data to remote location etc...) then you can either
use a domain account, or use local accounts with matching usernames and
passwords on the SQL server and any machine it may connect to.

If your SQL proccess will never connect to File shares, or similar resources
on the network, then you should run it with a Local User account on the box.

But of course, this is just my opinion.

GL

"Kona" <kona_iron@.yahoo.fr> wrote in message
news:a1de658a.0404191607.75ec6a49@.posting.google.c om...
> Hello,
> My server is part of a W2K domain. What do you advice me as account to
> run my SQL*Server, service started with a domain user account or as
> local system ?
> I need advices from a security point of view.
> Thank's in advance|||Thank you for your opinion.

And I also agree to not use Local System, all the more since this
account as network access into the same W2K domain (that was not the
case under NT).

"GL" <GL@.noSpam.ReplyToNewsgroup.com> wrote in message news:<108ddd45gbs8k69@.news.supernews.com>...
> Depends on your requirements...
> First, I would personally never recommend running SQL in a production
> environment as Local System.
> If the SQL proccess will ever need to connect to file shares on other
> machines (like to backup data to remote location etc...) then you can either
> use a domain account, or use local accounts with matching usernames and
> passwords on the SQL server and any machine it may connect to.
> If your SQL proccess will never connect to File shares, or similar resources
> on the network, then you should run it with a Local User account on the box.
> But of course, this is just my opinion.
> GL
> "Kona" <kona_iron@.yahoo.fr> wrote in message
> news:a1de658a.0404191607.75ec6a49@.posting.google.c om...
> > Hello,
> > My server is part of a W2K domain. What do you advice me as account to
> > run my SQL*Server, service started with a domain user account or as
> > local system ?
> > I need advices from a security point of view.
> > Thank's in advance